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

220 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
putsch133493(None) 
butch125416542but_ch
cutch125116192cut_ch
dutch114713822dut_ch
hutch135414092hut_ch
kitsch1533352kitsch
mutch125016172mut_ch
patch125221222pat_ch
pitch125018412pit_ch
punch125118422pu_nch
push95526622pu_s_h
puts65641752puts__
putsches1535312putsches
aitch105216163ait_ch
attach11118393attach
autarch1246623autarch
batch124620103bat_ch
bitch125017763bit_ch
borsch1336133borsch
botch126717453bot_ch
bunch125118603bu_nch
bush96630713bu_s_h
buts67247693buts__
catch125120373cat_ch
clutch13367753clut_ch
crutch13408243crut_ch
cuish10313173cuis_h
culch124512833cu_lch
cultch13385953cultch
curch124415413cu_rch
cuts65841153cuts__
detach12310413detach
ditch115015093dit_ch
dunch115316263du_nch
etch95419143_et_ch
eunuch1154363eunuch
fetch134913473fet_ch
fetich1479693fetich
fitch134816873fit_ch
flysch1732893flysch
grutch12285563grut_ch
gulch113810603gu_lch
gursh94512333gurs_h
gush85424003gu_s_h
guts56637253guts__
gutsy96412843guts_y
hatch135719593hat_ch
hitch134515473hit_ch
hotch136214723hot_ch
hunch136416213hu_nch
hush105224113hu_s_h
huts76737443huts__
itch95619173_it_ch
juts115930163juts__
ketch144912023ket_ch
kirsch1532713kirsch
kitschy1941983kitschy
klatsch1651683klatsch
latch104620463lat_ch
letch105215803let_ch
lunch104917243lu_nch
lurch104814633lu_rch
lush75327693lu_s_h
match125621103mat_ch
matsah1138233matsah
mensch13387083mensch
much115224033mu__ch
mulch124012973mu_lch
munch124917103mu_nch
musca9311763mu_sca
mush94929123mu_s_h
musth105314783mu_sth
muts64839983muts__
natch105018223nat_ch
nautch1144813naut_ch
notch105613323not_ch
nuts45032673nuts__
nutsy85711503nuts_y
ouch95724633ou__ch
outact8317203outact
outecho1244893outecho
outs45746963outs__
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
outsee63121803outsee
outset64027453outset
outsin63617553outsin
outsit63620883outsit
painch133511323painch
parch125123003p_arch
pash95638133p_as_h
pataca10311193pataca
patchy16509573pat_chy
path99134913pat__h
pats66460853pats__
patsy105717203pats_y
paunch13369853paunch
peach125422493p_each
pech116125453p__ech
perch124518833p_erch
pets66248333pets__
petsai838083petsai
phuts104613503phuts__
pinch125619303p_inch
pisco96314983p_isco
pish96127913p_is_h
pitchy16479673pit_chy
pith95432693pit__h
pits66348743pits__
pitsaw1135613pitsaw
planch133711443planch
plash104616563plas_h
pleach134211243pleach
plench134010813plench
plush105614713plus_h
poach124917863p_oach
pooch124815303p_ooch
porch125918623p_orch
posh95427323p_os_h
potash1138273potash
potiche1438043potiche
potlach14106363potlach
pots66452363pots__
potsie83916023potsie
potsy105815613pots_y
pouch124617083p_ouch
pouts75530323pouts__
preach133613923preach
prutah1136583prut_ah
prutoth1243473prutoth
psych1554963p_sych
pubic114513713pubic_
pubs85029213pubs__
puce85127883pu__ce
puck124927943pu__ck
pudic104614563pudic_
puds75630513puds__
pugh106619233pu__gh
pugs76332773pugs__
puisne856353puisne
pujah17478543pu_jah
puls65437563puls__
pulsar8329363pulsar
pulse74219973puls_e
pulsed94013723pulsed
pulser84215193pulser
pulses83818663pulses
pumice1238223pumice
punchy16398523pu_nchy
punish111411503punish
punkah15347093punkah
puns66641483puns__
punts75828003punts__
pups86032233pups__
purdah12288753purdah
purs65641043purs__
purse76028893purs_e
pursed95220883pursed
purser85020473purser
purses84826373purses
pursue84512253pursue
pursy105016413purs_y
pus55547843pu_s__
puses75532203pu_ses
pushy134614353pu_shy
puss64830133pu_s_s
pusses84322843pusses
pussly11407373pussly
pussy105614843pu_ssy
put55759073put___
putlog965553putlog
putoff1436423putoff
puton73617913put_on
putons83515153putons
putout8315113putout
putrid9311163putrid
putschist1644183putschist
putt66937843put__t
putted94220253putted
puttee85919723puttee
putter83921443putter
putti76018743put_ti
puttie84116303puttie
putto75617663put_to
putts75719273put_ts
putty104721403put_ty
putz158326323put__z
putzed18409113putzed
putzes174212523putzes
quaich2047693quaich
quash174512163quas_h
quench2036633quench
quitch2036413quitch
qursh174110843qurs_h
ratch104221363rat_ch
retch104818303ret_ch
rotch105815933rot_ch
rush76628183ru_s_h
ruth76825993rut__h
ruts44541493ruts__
scutch13247083scut_ch
smutch13205843smut_ch
stich104117923_stich
such96424813su__ch
sumach135310113sumach
tach96132753__tach
tech95925443__tech
tusche1136783tu_sche
tush74523903tu_s_h
tussah9356233tussah
tusseh9448423tusseh
tuts45838453tuts__
uptick1436763uptick
uts35534373_uts__
vetch134411843vet_ch
watch135617063wat_ch
witch134517563wit_ch
yucch15417433yu_cch
yuch125818533yu__ch

Search took 10 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.1701051123.5
2DLD Change Limit1127162209.12612351.1
3Display Results2202200.0762894.7
 (SQL Overall)1786912209.37219066.5
 
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.