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 “improvs” 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.

106 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
improvs143500(None) 
improv1344641improv_
improve1435961improve
improves1536121improves
impious1137062impious
imporous1246302imporous
imports11309622imports
impress1137772impress
improved1644772improved
improver1545242improver
improvers1645042improvers
improvise1674852improvise
amorous9311133amorous
approve14116603approve
approves15126833approves
aprons8316993_aprons
cuprous1149743cuprous
dimerous1139323dimerous
disprove14138193disprove
disproves15158513disproves
emerods10137653emerods
emperors1256123emperors
employs1455523employs
empress1138163empress
imagoes10126403imagoes
imagos9117553imago_s
imarets9138643imarets
imbrown1443883imbrown
imbrowns1543263imbrowns
imbrues1135503imbrues
impacts13266503impacts
impairs1135823impairs
impalas11236953impalas
impales113311763impales
imparks15276663imparks
imparts11298533imparts
impawns1433323impawns
impedes124310093impedes
impels10389523imp_els
impends12376803impends
imperils1247713imperils
imperious1346583imperious
impetus1144893impetus
imphees1436693imphees
impings12348553impings
impis96213853imp__is
implies11312123implies
implode12156103implode
implodes13106393implodes
implore11176703implore
implores12127043implores
impone103011863imp_one
impones112712253impones
import102713763imp_ort
impose103113053imp_ose
imposes113213683imposes
impost103011783imp_ost
imposts11269003imposts
impregn1243403impregn
impregns1343643impregns
impresa1134753impresa
impresas1244453impresas
imprese1138143imprese
impreses1238093impreses
imprest11310203imprest
imprests1246313imprests
imprimis1444253imprimis
imprint11312563imprint
imprints1247303imprints
imprisons1344913imprisons
improper1444533improper
improving1745413improving
improvised1873563improvised
improviser1773313improviser
improvises1784593improvises
improvisor1782763improvisor
imps86221123imp___s
impugns1243333impugns
imputes1138083imputes
incross937663incross
introns73515023introns
intros64215773intro_s
irons55324133i__rons
leprous938843leprous
microns113814783microns
micros104115363micro_s
mikrons13428413mikrons
mirrors938623mirrors
morons84919543_morons
nimrods1044283nim_rods
proas75028803__proas
prods85523553__prods
profs105120893__profs
progs86624153__progs
proms95426413__proms
props95726883__props
pros65742783__pro_s
pross76529403__pross
prove104823193__prove
proves114322253__proves
prows106327013__prows
repros84216003repro_s
reprove122911073reprove
reproves132011473reproves
timorous1047433timorous
upprops1044223upprops

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271066.39020974.5
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.82626178.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.