Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “proved” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
proved12501603(None) 
droved114611641droved
groved114413701groved
probed114114821probed
prosed94921091prosed
prove104823191prove_
proven114314771proven
prover113819721prover
proves114322251proves
roved95323551_roved
approved16115072approved
aproned10311502aproned
braved124817442braved
browed125216392browed
coved115027372_coved
craved125417772craved
crowed124717292crowed
droned84616862droned
drove95518062drove_
drover104614592drover
droves105116672droves
eroded84313582eroded
gloved114811872gloved
graved114818812graved
grooved12347252grooved
groped107515052groped
grove95219332grove_
grovel104310542grovel
groves104318102groves
hooved134713122hooved
improved1644772improved
ironed74916012ironed
loved95021362_loved
moved114218152_moved
paroled104217612paroled
paved115525262p_aved
peeved124112882peeved
phoned124014552phoned
plover115312612plover
plowed124213202plowed
ployed124310562ployed
poked125425392p_oked
poled84934842p_oled
pooed85226242p_ooed
poohed123912522poohed
pooled94619812pooled
pooped113915942pooped
poove104514302poove_
pooves113914712pooves
pored85234512p_ored
porked134717622porked
ported94223242ported
posed85828412p_osed
poxed154817862p_oxed
prated94924922prated
prayed124815432prayed
preed85128112pr_eed
premed114617752premed
prevued1337142prevued
preyed125313192preyed
priced115018882priced
prided103618032prided
pried84426862pr_ied
primed115118912primed
prised94322202prised
privet113821342privet
prized184415392prized
probe94320812probe_
prober104516072prober
probes104119452probes
proceed12310542proceed
prod76129502pro__d
prodded1257732prodded
proem94818272pro_em
progged12409792progged
projet15315182projet
prole74527792prole_
proleg94612112proleg
proles84627202proles
promoed12310082promoed
prone75332622prone_
pronged113912392pronged
proofed13138722proofed
propel103714062propel
propend123311272propend
proper104319952proper
propped113311952propped
prose75835122prose_
proser84223462proser
proses84733472proses
protea82214762protea
protei82615302protei
proteid103513662proteid
protend104012792protend
proud84615482pro_ud
proverb14378212proverb
provers123817792provers
provide1339852provide
provided1536842provided
provoked1875052provoked
prower114218122prower
prowled13309902prowled
pruned93413112pruned
raved94931432_raved
reproved14199472reproved
rived94825612_rived
robed85323732_robed
roped84630802_roped
rosed65930342_rosed
rove75136982_rove_
roven85521972_roven
rover85527372_rover
roves84834482_roves
rowed94034322_rowed
shoved134214272shoved
troked114114582troked
trove85221922trove_
trover95014662trover
troves94719112troves
trowed104714652trowed
unproved1457532unproved

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.1101624463.6
2DLD Change Limit825511212.84629006.0
3Display Results1211210.0432814.0
 (SQL Overall)1786911212.99959583.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.