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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
winsomer134577(None) 
winsome1237461winsome_
incomer1169942_incomer
isomer8310152_i_somer
misnomer1247142misnomer
ransomer1047882ransomer
wingover1544302wingover
winnower1444252winnower
winsomely1743192winsomely
winsomest1444332winsomest
capsomer1445773capsomer
consoler102812613consoler
consumer1238503consumer
handsomer1545453handsomer
income10712093_income_
incomers1268593_incomers
incomes11712373_incomes
informer13227283_informer
inhumer1275383_inhumer
insaner7310443_insaner
insider849733_insider
insofar1043543_insofar
insole63515863_insole_
insoles73516243_insoles
insurer73312803_insurer
intoner7811673_intoner
invoker1435363_invoker
ionomer939833_ionomer
isomers9310043_i_somers
kinsmen1335653kins_men
kinswomen1852753kinswomen
lissome937583lissome_
minster93914323mins_ter
misnomers1346183misnomers
monomer11311893mon_omer
oinomel946353oin_omel
pinscher1544803pinscher
ransomed1146933ransomed
ransomers1146873ransomers
rinser64317213rins__er
unsober967643_unsober
venomer1237583ven_omer
wagsome1345213wagsome_
wailsome1344493wailsome_
wantoner1187563wantoner
welcomer1544023welcomer
widower1435343wi_dower
willower14127453willower
wincer115018193win__cer
wincher153410653win_cher
winder104025263win__der
windhover1942463windhover
windier113412163win_dier
windowed1635573windowed
windrower1644223windrower
winger104125443win__ger
wingier113413283win_gier
wingmen1336113win_gmen
wingovers1643553wingovers
winier94522453win__ier
winker134220293win__ker
winner94219933win__ner
winnowed1543473winnowed
winnowers1543953winnowers
winoes94317013win_o_es
winter94222803win__ter
winterer112110443winterer
wintrier1136873wintrier
wiser85522803wi_s__er
wisher123617063wi_s_her
wispier12249403wi_spier
woesome1246733woesome_

Search took 8 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.1561145455.1
2DLD Change Limit146162727.31319986.6
3Display Results72720.0164500.0
 (SQL Overall)178691727.48523873.2
 
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.