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

165 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
spatzle183458(None) 
spaetzle1942241spaetzle
spatzles1935301spatzles
skatole1135692skatole
spackle15369572spackle
spaetzles2042152spaetzles
spale74929212spa__le
spangle1038402spangle
sparkle133710212sparkle
spate74731582spat__e
spathe115115692spat_he
spatula935892spatula
spittle937922spittle
sprattle1054762sprattle
apatite9312963apatite
asparkle1443843asparkle
battle85217863_battle
brattle9249253brattle
cattle85118903_cattle
dazzle1536853_dazzle
frazzle18305223frazzle
paddle104615143_paddle
padle84522343_pa_dle
pale66055013_pa__le
pantile93918483_pantile
papule102212133_papule
parle75836163_pa_rle
parole84425253_parole
pate65350463_pat__e
patine85328123_patine
patly105020583_pat_ly
pattee84323383_pattee
pattie84020963_pattie
patzer173111643_patzer
pettle84116053_pettle
pizzle16279493_pizzle
pottle84416103_pottle
prattle9208833prattle
puzzle16318603_puzzle
rattle64717613_rattle
sable74732163s_a_ble
saddle83915493s_addle
sale44959703s_a__le
sample104215013s_ample
sate45556103s_at__e
satire63218003s_atire
saxatile1544953saxatile
scabble13168653scabble
scale74629143sca__le
scathe114414993scat_he
scuttle936463scuttle
sectile9311973sectile
settle63915663s_ettle
sextile1438573sextile
shackle16409543shackle
shale85332833sha__le
shamble14149263shamble
shuttle1046103shuttle
sizzle14309613s_izzle
skate94721553skat__e
skatol1035723skatol_
skatoles1236143skatoles
skatols1135533skatols
skittle1135533skittle
slate55438283slat__e
smaze165012933sma_z_e
snaffle13216253snaffle
snathe94415113snat_he
snoozle16305913snoozle
space95325673spa__ce
spackled17297803spackled
spackles16319953spackles
spade84423323spa__de
spadille1145193spadille
spae65034323spa___e
spahee11313443spa_hee
spail74921553spa_il_
spails84817823spa_ils
spake114322743spa__ke
spales84728103spa__les
spall74919303spa__ll
spalled103113133spa_lled
spaller92713473spa_ller
spalls84217343spa_lls
spancel1147363spancel
spangled1236153spangled
spangles1138893spangles
spangly1336473spangly
spaniel948923spaniel
spansule1043623spansule
sparable121611983sparable
spare75135563spa__re
sparely123410673sparely
sparge94216053spa_rge
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparkly16348133sparkly
sparse84516343spa_rse
spat66548523spat___
spates85028173spat_es
spathal1236263spathal
spathed134013183spathed
spathes125116533spathes
spathic1437543spathic
spathose1345633spathose
spatial9310323spatial
spats75031383spat__s
spatted104014143spatted
spatter94016523spatter
spatular1044653spatular
spatulas1045473spatulas
spatulate11107173spatulate
spavie113611383spa_vie
spaz155626163spa_z__
spazz155811133spa_z_z
spazzes1735263spazzes
speckle15297553speckle
spicule11269933spicule
spile75230083sp__ile
spindle103210093spindle
spinule9299993spinule
spital83813873spital_
spitals93011593spitals
spite75430663spit__e
spittles1038333spittles
spitz166017973spitz__
spitzes1849183spitzes
sporule937273sporule
spraddle12194163spraddle
sprattled1263313sprattled
sprattles1174883sprattles
spurtle937453spurtle
stabile9312063stabile
stable83921643sta_ble
staddle9288093staddle
stale55637103s__tale
staple84415823sta_ple
startle72511123startle
statable10310703statable
statal61613223statal_
state56237333stat__e
stately10310223stately
statice92614033statice
stative102612933stative
statue66015323stat_ue
stature74410683stature
statute7419323statute
stele55026843s__tele
stile54931573s__tile
stole54928813s__tole
style85519363s__tyle
suable83920553sua_ble
subtile91912623subtile
subtle82113433subt_le
swaddle12276743swaddle
swale85221593swa__le
swathe125514113swat_he
swizzle1854103swizzle
systole1035763systole
tattle64115653_tattle
teazle15329553tea_zle
twattle1064273twattle
wattle94314213_wattle

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271655.93622578.7
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.38927968.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.