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

433 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
ditsier8301029(None) 
bitsier9379071bitsier
ditzier17307961ditzier
antsier7410772antsier
artsier768942artsier
bittier94211662bittier
diaster82813312diaster
dicier94416232di_cier
dickier143512452dickier
dictier103411862dictier
diester83013682diester
dingier93513662dingier
dinkier123411502dinkier
dippier123111392dippier
dirtier83312092dirtier
dishier113613402dishier
ditcher134012002ditcher
dither104417682dit_her
ditsiest92111322ditsiest
ditties83116982ditties
dizzier16317542dizzier
dossier83711692dossier
dotier73917032dot_ier
dottier83910922dottier
dustier83814132dustier
gutsier8389822gutsier
hissier103410502hissier
mistier93418712mistier
mitier83620662mit_ier
nittier73512242nittier
nutsier7329252nutsier
pithier123010292pithier
pitier84019822pit_ier
ritzier16297202ritzier
sissier73711362sissier
tipsier9268892tipsier
withier132910492withier
wittier103910822wittier
airier64619363ai_rier
artier63419733art_ier
battier93515713battier
bilgier10358533bilgier
bister84922763bi_ster
bitchier15307733bitchier
biter75030033bit__er
bitsiest102610063bitsiest
bitter84622673bit_ter
bossier93712423bossier
brasier94516753brasier
busier85219723_busier
bustier93916153bustier
cattier93317073cattier
cissies94116153cissies
citer74827323cit__er
cither114616683cit_her
citied94014143cit_ied
cities84524853cit_ies
cosier84423753_cosier
cottier93814173cottier
crosier94116573crosier
cutesier1045623cutesier
dabster1036703dabster
daffier1457833daffier
daintier937403daintier
daisied93410013daisied
daisies84217093daisies
dallier84215373dallier
dandier93714573dandier
dasher104318983d_asher
dashier114311183dashier
dassie74615573dassie_
dassies84418663dassies
dater65332313dat__er
daubier1037093daubier
decrier102713553decrier
deedier93011593deedier
defier105118653d_efier
deifier113013123deifier
deities82621923deit_ies
denier74420693d_enier
denser74115193dens_er
dernier83011943dernier
desire7415303d_esire
desirer8310783d_esirer
destrier9311823destrier
detailer9268673detailer
detainer92910793detainer
deter65028043det__er
detester9239683detester
deviser114212393deviser
dewier104013463d_ewier
dialer74315433di_aler
dialler848813dialler
diaper94513113di_aper
diapir9357113diapi_r
diaries83321953diaries
diastem10318043diastem
diasters92913173diasters
dibber114614713di_bber
dibbler124510283dibbler
dicer85426423di__cer
dicker134521403di_cker
dickie133913113dickie_
dickies143416343dickies
diddler103511513diddler
didie74120563di_die_
didies84621833di_dies
diesel74410403dies_el
dieses75218693dies_es
diesinker1462513diesinker
diesis74013493diesi_s
diesters92513593diesters
dieter73516773di_eter
diether1147443diether
differ133910843di_ffer
digester10258423digester
digger94616083di_gger
diker105524553di__ker
dilater83515643dilater
dillies84122153dillies
diluter8319653diluter
dimer85625603di__mer
dimeter10411893dimeter
dimmer114112613di_mmer
dimplier1336673dimplier
diner65632903di__ner
dinger85323663di_nger
dingies93618243dingies
dinkies123716033dinkies
dinner74217153di_nner
diopter1038473diopter
dipper114017783di_pper
direr64927073di__rer
dirtied93210853dirtied
dirties83119383dirties
disaster949943disaster
disbar938513di_sbar
disced104914653di_sced
discern1038493di_scern
diseur738843di_seur
dished114318713di_shed
dishes104622653di_shes
disinter9310673di_sinter
disked125015763di_sked
disliker13358643disliker
disme85716243di_sme_
dismes95617673di_smes
dispel9310323di_spel
dissed85220173di_ssed
dissert83720693di_ssert
disses75225963di_sses
dissever12107653dissever
dissing94517683dissing
distich13312173distich
distil73616433disti_l
distill83011323distill
distiller1046663distiller
distils83015803distils
ditched143711903ditched
ditchers143610363ditchers
ditches133215713ditches
dite55547553dit__e_
dites66339153dit__es
ditherer12187763ditherer
dithers114016153dit_hers
dithery14318943dit_hery
dithiol1145433dithiol
dits56450523dits___
ditsiness1048133ditsiness
ditsy95612563dits__y
dittoed936733dittoed
ditzes163212423dit_zes
ditziest18218473ditziest
diver94827803di__ver
divider12278953divider
diviner11369883diviner
divisor11345573divisor
divvied1544813divvied
divvies1457663divvies
dizzied17236133dizzied
dizzies16279753dizzies
dodgier10388243dodgier
doggier103810943doggier
donsie7613643donsie_
doomier103610123doomier
dopier93515923d_opier
dorkier122810023dorkier
dorser74819173dors_er
doser66228563d_os_er
dosser74417973d_osser
dossiers9318043dossiers
doter65428623dot__er
dotter74419343dot_ter
douser75621633dous_er
dowdier12328573dowdier
downier11299703downier
dowser104716083dows_er
dozier163611633d_ozier
dresser83611953dresser
dressier956863dressier
drier64423963d__rier
driftier1275123driftier
drippier1385043drippier
drossier956313drossier
drowsier1284903drowsier
duckier143911793duckier
dumpier12409653dumpier
dungier9368583dungier
duskier12409423duskier
duster74919723d_uster
duties74921903dut_ies
easier64218463_easier
edifier11309263edi_fier
either94517423eit_her
fattier103513463fattier
feistier1136193feistier
fibster12146533fibster
fierier103511193fierier
filmier1237503filmier
filthier1434073filthier
finnier10319943finnier
firrier103410123firrier
fisher124917143fi_sher
fishier13359853fishier
fitter94120033fit_ter
fizzier18326713fizzier
flimsier1344133flimsier
fubsier12367763fubsier
fussier103610673fussier
fustier104213933fustier
gassier83812573gassier
giddier10308723giddier
gimpier12247933gimpier
ginnier8298973ginnier
gipsied1135873gipsied
gipsies1039903gipsies
girlier8289523girlier
glitzier1833593glitzier
goosier83512563goosier
gorsier83811073gorsier
grittier9316263grittier
gustier83813863gustier
guttier83911103guttier
hastier103916623hastier
hillier103413963hillier
hinkier143610793hinkier
hippier143212103hippier
hipster12288783hipster
hisser94713793hi_sser
hissies103915823hissies
hitcher153712003hitcher
hither124417253hit_her
hitter94419863hit_ter
horsier103013243horsier
hosier94219613_hosier
icier74313743_i_cier
ickier12439913_ickier
iffier1236753_iffier
inkier104013773_inkier
inlier63615353_inlier
insider849733_insider
issuer646623_issuer
itchier12247673_itchier
ither84617603_it_her
jettier14358693jettier
jiggier16377823jiggier
jitter133314993jit_ter
jivier16438613ji_vier
kickier12349053kickier
kiester11329973kiester
kinkier10319433kinkier
kisser104212453ki_sser
kiter95523213kit__er
kitties113213623kitties
kittler11338163kittler
lathier10310833lathier
limbier11349093limbier
limier83518713li_mier
limpsier1234433limpsier
lingier84113373lingier
linier64423783li_nier
lintier73613793lintier
lippier112710573lippier
lisper84114433li_sper
lister64527253li_ster
liter54736343lit__er
lither94520953lit_her
litter64324853lit_ter
littler7348553littler
livier97514593li_vier
lousier72411623lousier
lustier73813503lustier
luthier1038233luthier
massier93615223massier
matier84321523mat_ier
messier93412923messier
metier83517693met_ier
miffier1537023miffier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512463mincier
mingier103815283mingier
minster93914323minster
mintier93615993mintier
mirier83918353mi_rier
mirkier13319053mirkier
miser75430403mi_s_er
missies93423983missies
mister84728563mi_ster
miter75734793mit__er
miterer92511333miterer
mither114218563mit_her
mitises9315543mitises
mossier94413813mossier
mothier121910213mothier
motlier92010583motlier
mousier93712463mousier
mussier93314353mussier
mustier94017953mustier
mythier15125183mythier
nastier74115293nastier
nattier73614623nattier
nettier74211813nettier
newsier10147223newsier
niftier10328713niftier
nippier11319833nippier
niter55028973nit__er
noisier759453noisier
nosier63716323_nosier
nuttier73112023nuttier
oilier64417233oi_lier
osier53518013__osier
outlier72216143outlier
outsider9269643outsider
pastier94320383pastier
patsies93919483patsies
pestier94317403pestier
pettier94213613pettier
piaster93012883piaster
pickier153912973pickier
piggier113510003piggier
pilsner935343pilsner
pinier84024693pi_nier
pipier104913983pi_pier
pisher114317753pi_sher
pisser84416383pi_sser
pitcher143813713pitcher
pitchier15368273pitchier
pitied94017253pit_ied
pitiers93812653pit_iers
pities83828083pit_ies
potsie83916023potsie_
potsies93019483potsies
pottier93516493pottier
prissier10157873prissier
prosier93817483prosier
pursier94012753pursier
pussier93711993pussier
puttier93314503puttier
rattier74015593rattier
ribbier1137583ribbier
ribier84414223ri_bier
ridgier937883ridgier
rimier83916263ri_mier
rinser64317213rins_er
riser55431053ri_s_er
risker105414493ri_sker
riskier1138423riskier
ritter63822413rit_ter
rosier64221263_rosier
rustier74416363rustier
ruttier73412283ruttier
sassier73413233sassier
shittier1137303shittier
silkier114411643silkier
sillier74017583sillier
siltier73413863siltier
sissies73716603sissies
sister64421583si_ster
sitter63323383sit_ter
sizier1514813393si_zier
slimsier1085213slimsier
slittier837003slittier
sonsier7711743sonsier
sudsier868773sudsier
tarsier74119253tarsier
tastier711817093tastier
tattier74216243tattier
testier74015643testier
tidier73515113ti_dier
tier44936143__t_ier
tinier63622233ti_nier
tinnier72910133tinnier
tippier113210543tippier
tipster9299053tipster
titer55430613tit__er
titfer9409523tit_fer
tither94920283tit_her
titter63421163tit_ter
tittie63213153tittie_
titties73617363titties
trier54328533__trier
twier84713293__twier
twistier1134813twistier
vastier103613203vastier
viewier1334983viewier
vinier93716743vi_nier
visiter1038863vi_siter
vitamer1235473vitamer
vizier184311023vi_zier
whitier133311063whit_ier
wiftier13297733wiftier
wiggier12418863wiggier
wilier93217073wi_lier
wimpier14248043wimpier
windier113412163windier
wingier113413273wingier
winier94522453wi_nier
wintrier1136873wintrier
wirier94215553wi_rier
wiser85522803wi_s_er
wisher123617063wi_sher
wispier12249403wispier
witchier16307883witchier
wither124321353wit_her
withies133913543withies
wristier1136863wristier
wussier10408083wussier
zestier163010223zestier
zingier17369483zingier
zippier20308193zippier
zither183813083zit_her

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.1561145455.1
2DLD Change Limit1340274337.32618294.7
3Display Results4334330.1732502.9
 (SQL Overall)1786914337.65523343.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.