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

120 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
insulter83688(None) 
insulted937191insulted
insulters945881insulters
consulter1198222consulter
indulger1044152indulger
inputter1034202inputter
inserter82312132inserter
insetter8218592insetter
insister888782insister
insular7138702insul_ar
insulate8312842insulate_
insulated10310712insulated
insulates9311842insulates
insulator948102insulator
insult62813672insult__
insults7268962insult_s
insurer73312802insu_rer
assaulter942753assaulter
consulted1277923consulted
consulters1297213consulters
consultor1176473consultor
coulter94115603_coulter
desalter938363desalter
ensurer73011903ensu_rer
imputer1136533impu_ter
incenter102212093incenter
inciter93113773in_citer
incult82414773incult__
incumber1444553incumber
indenter92311443indenter
indicter1148143indicter
inditer83514233in_diter
inducer10318763indu_cer
inducted1237273inducted
inductee1158053inductee
inductor1146333inductor
indulge945403indulge_
indulged1144073indulged
indulgers1143803indulgers
indulges1045263indulges
indult73614033indult__
indults8289493indult_s
infecter13229153infecter
infester11239433infester
inflater1149893inflater
infolder1256433infolder
infuser10298323infu_ser
ingulfed1343173ingulfed
inhaler1068053inhal_er
inhauler1163943inhaul_er
inholder1276113inholder
inhumer1275383inhu_mer
injurer14318473inju_rer
inlier63615363in__lier
inputted1134663inputted
inputters1143443inputters
inquirer17235173inquirer
insaner7310443ins_aner
insculped1442703insculped
inselberg1241843inselberg
inserted92413053inserted
inserters92210283inserters
insetted9249023insetted
insetters9187133insetters
insider849733ins_ider
insisted998673insisted
insisters997653insisters
insnarer865303insnarer
insolate8311893insolate_
insolated1039713insolated
insolates9311273insolates
insole63515863insol_e_
insoles73516243insol_es
insouled936113insoul_ed
inspirer1045183inspirer
installer945013installer
instanter946243instanter
instar6310013ins__tar
instate71616483instate_
instated91613343instated
instates81615833instates
instep838193ins__tep
instiller944953instiller
insulant849883insulant
insulars8137323insulars
insulators1047263insulators
insulin738483insul_in
insulins848863insulins
insulting1038053insulting
insure63416603insu_re_
insured83714253insu_red
insurers83710133insu_rers
insures73117263insu_res
inter55028493in___ter
intuited938763intuited
inventer112410843inventer
inverter112411073inverter
inviter104112313in_viter
involver1444663involver
issuer646623issu__er
minster93914323mins__ter
minuter93510413min_u_ter
misalter1038343misalter
moulter93812423_moulter
neuter63713793_neu_ter
nutter63918053_n_utter
occulter1244113occulter
pinsetter1145013pinsetter
poulter93712013_poulter
psalter9247813_psalter
resulted939713resulted
salter64325083__salter
suiter64121813__suiter
sulker104015923__sulker
sutler63718393__sutler
unrulier845333unrulier
unsalted9510923unsalted
unsolder937213unsolder
unsuited9310793unsuited
vaulter10257713_vaulter

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621206.20323563.1
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.66926794.3
 
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.