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

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

89 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
rowan8541873(None) 
gowan95415741gowan
rewan85623661rewan
roan47234201ro_an
roman75424821roman
rowans95715341rowans
rowen84921151rowen
ajowan1634892ajowan
bogan87519002bogan
bowman13129852bowman
brogan9311042brogan
brown105619532brow_n
cotan71521782cotan
cowman13910372cowman
crown105620082crow_n
dewan95718042dewan
diwan95712552diwan
down86427492dow_n
drown95515822drow_n
frown115415972frow_n
goban84414072goban
gowans105512292gowans
gowany13457492gowany
gown85724072gow_n
groan65618422gro_an
grown95317352grow_n
hogan97817702hogan
honan85319772honan
hwan105716892_hwan
jawan15710382jawan
jowar155211432jowar
koan85425032ko_an
loan47436452lo_an
logan68123282logan
loran55925092loran
lown76929292low_n
moan65832022mo_an
mown95424442mow_n
noway111112842noway
organ6915392organ
own66429702_ow_n
prolan8414692prolan
prowar114110942prowar
ran38266622r__an
ratan53722662ratan
rawin85521472rawin
redan66125012redan
reman75730152reman
reran57329102reran
rewax155713922rewax
rewin85623962rewin
rewon86920582rewon
road56332112ro_ad
roam67132412ro_am
roans54926442ro_ans
roar46328572ro_ar
roband92310722roband
robin74820282robin
rodman949712rodman
romano84912942romano
romans84620242romans
rosin55325312rosin
rota45834342rota_
rotas54827722rotas
rouen54920902rouen
roven85521972roven
row67453672row__
rowdy125711532rowdy
rowed94034322rowed
rowel84721412rowel
rowens94515302rowens
rower85430492rower
rowing103623302rowing
rows75941752row_s
rowth115713232rowth
royal85014702royal
ryokan1353752ryokan
sewan85921292sewan
solan55328152solan
soman75024902soman
sowans94215892sowans
sowar85821342sowar
sown75127452sow_n
swan76631312_swan
tolan55124012tolan
toman75724052toman
town76928702tow_n
wan66761942__wan
woman105818002woman

Search took 3 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 Filter178691538000.373479064.3
2DLD Change Limit53800891.98327130.6
3Display Results89890.0165562.5
 (SQL Overall)178691892.37275333.5
 
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.