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

134 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
kirsch153271(None) 
kitsch1533351kitsch
birch124914022bir_ch
borsch1336132borsch
girsh95310022girs_h
kirs85831732kirs__
kirsches1743842kirsches
kitschy1941982kitschy
airs46447423airs__
airsick1395333airsick
airth85621023air_th
aitch105216163ai_tch
arch98628443_ar_ch
birse74517403birs_e
birses84717733birses
birth105619873bir_th
bitch125017763bi_tch
borscht1445993borscht
brach126123303_brach
caroch13911763caroch
cinch124516243ci_nch
circa9311403cir_ca
cisco95112133ci_sco
curch124415413cur_ch
direct93817333direct
disc76123233di_sc_
disci85815023di_sci
disco85616073di_sco
discs85316263di_scs
dish86328333di_s_h
ditch115015093di_tch
enrich1138943enrich
fiaschi1542793fiaschi
fiasco11104923fiasco
filch134813323fi_lch
finch135416973fi_nch
firs76637713firs__
first86226123firs_t
firsts95110923firsts
firth115819533fir_th
fisc96819753fi_sc_
fiscs105311883fi_scs
fish106926273fi_s_h
fitch134816873fi_tch
flysch1732893flysch
girth95618843gir_th
grinch1238473grinch
gursh94512333gurs_h
harsh116418053hars_h
hirsel9138683hirsel
hirsle9159573hirsle
hitch134515473hi_tch
ich86227743_i__ch
inch95420823_i_nch
itch95619173_i_tch
karst97228993kars_t
karsts106012943karsts
keirs95313673keirs__
kench145513923k_ench
kersey1336783kersey
ketch144912023k_etch
khirkah1641423khirkah
kiaugh1442813kiaugh
kibbeh17406063kibbeh
kiblah1535583kiblah
kibosh1534263kibosh
kick96026063ki__ck
kids96029633kids__
kiers95320093kiers__
kifs116023503kifs__
kimchi1743803ki_mchi
kins85747903kins__
kiosk836233kios_k
kiosks934383kiosks
kips106430513kips__
kir76535673kir___
kirk76221563kir__k
kirks84915263kir_ks
kirn87123433kir__n
kirned11408623kirned
kirns95315453kir_ns
kirtle10309473kirtle
kis78051473ki_s__
kiss85227393ki_s_s
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
kissy125510313ki_ssy
kist86540793ki_s_t
kists95822113ki_sts
kith115826353ki__th
kits86441763kits__
kitsches1734073kitsches
klatch15445933klatch
klatsch1651683klatsch
knish1238603knis_h
kors85933013kors__
kris86423603kris__
krises105016083krises
kvetch1832993kvetch
larch105919793lar_ch
lich96230843li__ch
liroth938383liroth
lurch104814633lur_ch
march125622893mar_ch
marsh105320853mars_h
mensch13387083mensch
merch125417963mer_ch
milch124413373mi_lch
mirs66940563mirs__
mirth106418893mir_th
orach105219233_orach
parch125123003par_ch
perch124518833per_ch
pibroch1643803pibroch
pinch125619303pi_nch
piracy1339473piracy
pisco96314983pi_sco
pish96127913pi_s_h
pitch125018413pi_tch
porch125918623por_ch
putsch1334933putsch
qursh174110843qurs_h
rich97025543__rich
sirrah9379753sirrah
sirs44338333sirs__
smirch1356463smir_ch
torch107420933tor_ch
wich125724743wi__ch
winch135016663wi_nch
wish107228733wi_s_h
witch134517563wi_tch
yirth116513753yir_th
zilch19438123zi_lch

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161345.31321215.1
3Display Results1341340.0304466.7
 (SQL Overall)1786911345.48332590.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.