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

112 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
spinach143540(None) 
spinachy1842791spinachy
pinch125619302_pin_ch
spinaches1645272spinaches
spinage10289652spinage
spinal84915312spina_l
spinals93911862spinals
spinate93114812spinate
chinch163911233chin_ch
cinch124516243_cin_ch
clinch133910353clin_ch
epinaoi945013epinaoi
epinaos936283epinaos
epitaph1444133epitaph
finch135416973_fin_ch
flinch144010103flin_ch
grinch1238483grin_ch
inarch1139173__inarch
inch95420823__in_ch
linac7315413_linac_
linacs8310813_linacs
painch133511323pain_ch
panache1458423_panache
peach125422493_p_each
picacho1644733_picacho
pina65842633_pina__
pinang92611593_pinang
pinas75434453_pina_s
pinata83817223_pinata
pinnace113510313_pinnace
piracy1339473_piracy
pitch125018413_pi_tch
planch133711443_planch
pleach134211243_pleach
poach124917863_p_oach
preach133613923_preach
punch125118423_pun_ch
shibah14387473shiba_h
shivah15488543shiva_h
since75024173s_in_ce
sinh76238043s_in__h
smirch1356463smi_rch
snack114718063s__nack
snash84815673s__nash
snatch114310603s__natch
snath86419803s__nath
snitch11357943sni_tch
space95325673sp__ace
spacy125415623sp__acy
speech1347563sp_eech
spence103813793spen_ce
spic85227433spi__c_
spica94717943spi__ca
spicae104313703spica_e
spicas104715823spica_s
spicate113214193spicate
spice95528813spi__ce
spick134519073spi__ck
spics94123243spi__cs
spicy125417713spi__cy
spilth11469733spi_lth
spin66231303spin___
spinages11289293spinages
spinally1338023spinally
spindle103210093spindle
spindly13257383spindly
spine76534423spin__e
spined95423943spin_ed
spinel85317333spin_el
spinels94512443spinels
spines85132033spin_es
spinet85629753spin_et
spinets94714813spinets
spinier93715163spinier
spinner93912263spinner
spinney12438923spinney
spinny114510183spin_ny
spinoff1544933spinoff
spinor839943spin_or
spinors939423spinors
spinose937943spinose
spinous9310443spinous
spinout9311583spinout
spins75327983spin__s
spinto8410663spin_to
spintos939133spintos
spinula9257903spinula
spinule9299993spinule
spiny104921303spin__y
spiracle1255803spiracle
spiraea9407983spiraea
spiral83715343spira_l
spirals93212513spirals
spirant9814293spirant
spital83813873spita_l
spitals93011593spitals
splash1168823sp_lash
splotch1442853splotch
squinch2134833squin_ch
stanch113812373stan_ch
stench114111163sten_ch
stich104117923sti__ch
stitch11419103sti_tch
stomach1436033stomach
sumach135310113s_umach
sunnah9369353sunna_h
supinate10310313supinate
swinish1347203swinish
switch14458913swi_tch
synch135011793s_yn_ch
upreach1444693upreach
winch135016663_win_ch

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.403443402.0
2DLD Change Limit1340271126.92319359.7
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.35924282.0
 
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.