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

118 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
sparrow123427(None) 
sparrows1344811sparrows
arrow83414892__arrow
barrow114512772_barrow
farrow12309982_farrow
harrow122610782_harrow
marrow112812612_marrow
narrow9269152_narrow
parrot8320662_parrot
sorrow9339442s_orrow
sparred104512862sparred
sparry115111302sparr_y
yarrow12287942_yarrow
arrows92813493__arrows
arrowy12288283__arrowy
barlow112911433_barlow
barrows123411693_barrows
borrow114310733_borrow
burrow114610813_burrow
carrom10513403_carrom
carrot8423123_carrot
charro114212963charro_
charros124312153charros
esparto944233esparto_
espartos1044333espartos
farrows13259793_farrows
furrow12427743_furrow
garron73113493_garron
harrows132611043_harrows
karroo10410013_karroo
marron83717543_marron
marrows122911833_marrows
marrowy15236093_marrowy
morrow113510093_morrow
narrows10258853_narrows
pardon94618733_pardon
pareo74632603_pareo_
pareos87023773_pareos
pargo86723723_pargo_
pargos95719043_pargos
parlor8312673_parlor
parol74826273_pa_rol
parr65731153_parr__
parral85517533_parral
parred95024073_parred
parrel84515983_parrel
parrots9312743_parrots
parroty1247863_parroty
parrs75928673_parr_s
parry105323753_parr_y
parson83817903_parson
parton84720993_parton
parvo107719183_parvo_
parvos116614753_parvos
patrol83213023_patrol
patron84018043_patron
perron83216623_perron
prow97030383_p__row
pyrrol1136273_pyrrol
safrol937283s_afrol
sallow94315753s_allow
sargo65424413s_argo_
sargos74318273s_argos
sarod65325873s_a_rod
saros55238063s_a_ros
sartor6313883s_artor
scarecrow1651603scarecrow
scarred104512633scarred
scarry116311183scarr_y
serow86720443s__erow
shadow1337253sha_dow
shallow13388873shallow
sorrows10278403s_orrows
spado83713703spa_do_
spambot1345913spambot
spar65433303spa_r__
spare75135563spa_r_e
spared95427493spa_red
sparely123410673sparely
sparer84524963spa_rer
sparerib1264363sparerib
sparers94519613sparers
spares84834553spa_res
sparest94616433sparest
sparge94216053spa_rge
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparid94016933spa_rid
sparids103512123sparids
sparing104823873sparing
spark114920893spa_r_k
sparked143513143sparked
sparker133914363sparker
sparkle133710213sparkle
sparkly16348133sparkly
sparks124616363spa_rks
sparky154511523spa_rky
sparoid102311543sparoid
sparrier10329143sparrier
sparring113112223sparring
spars75431543spa_r_s
sparse84516343spa_rse
sparser94311483sparser
spartan948333spartan
sporran936743sporran
spurred103610623spurred
spurrer93710223spurrer
spurrey12307813spurrey
spurry11429123spurr_y
stardom1037763stardom
starred85013453starred
starry94911673starr_y
strow88920573s__trow
swallow13355753swallow
upgrow1234273up_grow
upthrow1543193upthrow
yarrows13277863_yarrows

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271186.59320328.7
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.04525364.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.