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

98 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
sparrows134481(None) 
sparrow1234271sparrow_
arrows92813492__arrows
barrows123411692_barrows
farrows13259792_farrows
harrows132611042_harrows
marrows122911832_marrows
narrows10258852_narrows
parrots9312742_parrots
sorrows10278402s_orrows
yarrows13277862_yarrows
arrow83414893__arrow_
arrowy12288283__arrowy
barlows12259983_barlows
barrow114512773_barrow_
borrows12349263_borrows
burrows12399103_burrows
carroms11512403_carroms
carrots9714623_carrots
charros124312153charro_s
espartos1044333esparto_s
farrow12309983_farrow_
furrows13327793_furrows
garrons82713463_garrons
harrow122610783_harrow_
karroos1139313_karroos
marrons93216973_marrons
marrow112812613_marrow_
marrowy15236093_marrowy
morrows12318723_morrows
narrow9269153_narrow_
pardons103817623_pardons
pareos87023773_pareo_s
pargos95719043_pargo_s
parlors9312923_parlors
parlous9414293_parlous
parols84722613_pa_rols
parous84024163_pa_rous
parrals94414573_parrals
parrels94713493_parrels
parries93925853_parries
parrot8320663_parro_t
parroty1247863_parroty
parrs75928673_parr__s
parsons93516873_parsons
partons94620513_partons
parvos116614753_parvo_s
patrols93513513_patrols
patrons93818103_patrons
perrons93115483_perrons
prows106327013_p__rows
pyrrols1235403_pyrrols
safrols1036863s_afrols
sallows103915553s_allows
saporous1039053saporous
sarcous9312933s_arcous
sargos74318273s_argo_s
sarods74918573s_a_rods
saros55238063s_a_ro_s
sartors7314973s_artors
scabrous1245993scabrous
scarecrows1751583scarecrows
scarious10610203scarious
serows96016393s__erows
shadows1437193sha_dows
shallows14388863shallows
sorrow9339443s_orrow_
spacious1237813spacious
spambots1443313spambots
spareribs1353283spareribs
sparers94519613spa_rers
spares84834553spa_r_es
spargers11389733spargers
sparges104016343spa_rges
sparids103512123spa_rids
sparkers144111313sparkers
sparkles143210493sparkles
sparks124616363spa_r_ks
sparoid102311543spa_roid
sparoids11218713sparoids
sparred104512863sparr_ed
sparrier10329143sparrier
sparriest11198793sparriest
sparring113112223sparring
sparry115111303sparr__y
spars75431543spa_r__s
spermous1247933spermous
sporrans1045523sporrans
spurious1036963spurious
spurrers10338463spurrers
spurreys13364603spurreys
spurries102311323spurries
stardoms1136793stardoms
strows96718273s__trows
swallows14295893swallows
upgrows1334323up_grows
upthrows1643303upthrows
yarrow12287943_yarrow_

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.423422437.4
2DLD Change Limit146162987.50019488.3
3Display Results98980.0303266.7
 (SQL Overall)178691987.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.