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 “improves” with Change Limit: [1] [2] [3]

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

110 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
improves153612(None) 
improve1435961improve_
improved1644771improved
improver1545241improver
improvers1645041improvers
improvs1435001improv_s
approves15126832approves
disproves15158512disproves
implodes13106392implodes
implores12127042implores
impones112712252imp_ones
imposes113213682imp_oses
impreses1238092impreses
improper1444532improper
improv1344642improv__
improvise1674852improvise
improvises1784592improvises
proves114322252__proves
reproves132011472reproves
amarones10311353amarones
approve14116603approve_
approved16115073approved
approver15105303approver
approvers16104913approvers
depraves1436873depraves
deprives1438393deprives
disprove14138193disprove_
disproved16147343disproved
disproven15146473disproven
disprover15137073disprover
disprovers16145283disprovers
droves105116673__droves
employes1555943employes
emprises12311003emprises
emprizes2138133emprizes
groves104318103__groves
imagoes10126403imago_es
imbrowns1543263imbrowns
imbrues1135503imbr_ues
imbrutes1244203imbrutes
impales113311763imp_ales
impasses12257523impasses
impastes12238193impastes
impedes124310093imp_edes
imphees1436693imp_hees
impinges13297423impinges
impious1137063impio_us
implies11312123imp_lies
implode12156103implode_
imploded14145073imploded
implore11176703implore_
implored13135373implored
implorer12125103implorer
implorers13124413implorers
implosives1743053implosives
impone103011863imp_one_
imponed12279453imp_oned
imporous1246303imporous
imported13308693imported
importer12308913importer
importers13247763importers
imports11309623imp_orts
impose103113053imp_ose_
imposed123110293imp_osed
imposer113310103imp_oser
imposers12278453imp_osers
imposts11269003imp_osts
impower14247123imp_ower
impowers15296823imp_owers
impregns1343643impregns
impresa1134753impr__esa
impresas1244453impresas
imprese1138143impr__ese
impress1137773impr_ess
impresses1338213impresses
imprest11310203impr__est
imprests1246313imprests
imprimis1444253imprimis
imprints1247303imprints
improving1745413improving
improvised1873563improvised
improviser1773313improviser
improvisers1892773improvisers
improvisor1782763improvisor
impulses1235223impulses
imputes1138083imp_utes
irones64724013i__rones
microbes1439403microbes
mismoves1537293mismoves
moves106128423_m__oves
pooves113914713__pooves
probes104119453__probes
proles84627203__proles
proses84733473__proses
prove104823193__prove_
proved125016033__proved
proven114314773__proven
prover113819723__prover
provers123817793__provers
reprobes121910293reprobes
reprove122911073reprove_
reproved14199473reproved
reprover13229203reprover
reprovers14217773reprovers
roves84834483___roves
saprobes1237033saprobes
troves94719113__troves
unimproved1851753unimproved
unproved1457533unproved
unproven1365463unproven

Search took 9 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621107.86018595.7
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.05922172.9
 
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.