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

489 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
critters10351131(None) 
chitters133711161chitters
critter94113031critter_
critturs10374591critturs
fritters113810781fritters
gritters94210631gritters
ritters74020611_ritters
bitters94920352_bitters
chatters134213932chatters
chitter124112962chitter_
citers85022972c_i_ters
cithers124315752c_ithers
cittern9339132c_ittern
citterns10318112c_itterns
clatters103313902clatters
clutters103210342clutters
cointers103616402cointers
cotters94323432c_otters
crafters13419942crafters
craters95021882cr_aters
cribbers14306442cribbers
criers83918582cri__ers
crimmers14298542crimmers
crimpers14318932crimpers
cringers112511872cringers
crispers12309432crispers
crittur9315132crittur_
crofters13358892crofters
cutters94218952c_utters
drifters12417912drifters
emitters10349642emitters
fitters104517742_fitters
flitters114312172flitters
fretters113410302fretters
fritter103912772fritter_
glitters93710542glitters
grifters12389232grifters
gristers94013402gristers
gritter83913352gritter_
hitters104717582_hitters
jitters144314462_jitters
knitters12336622knitters
litters73422562_litters
omitters10277652omitters
printers103214902printers
quitters17238522quitters
ratters74422472_ratters
rioters73615502_rioters
ritter63822412_ritter_
rotters74421392_rotters
scripters13116672scripters
sitters74221542_sitters
skitters12349542skitters
slitters84014132slitters
spitters104113382spitters
titters74219612_titters
trotters83310232trotters
twitters11296772twitters
whitters14359402whitters
writers105513492wri_ters
writhers14398982writhers
abetters1057173abetters
abutters1056983abutters
acquitters2142953acquitters
admitters1244553admitters
arbiters1038853arbiters
ariettes8411353ariette_s
baiters94619303bai_ters
batters94626013_batters
betters94422093_betters
bisters93922603_bisters
biters83925233_bi_ters
bitter84622673_bitter_
bittern94810683_bittern
bitterns10428943_bitterns
blatters104414093blatters
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
blotters104110983blotters
bribers114111493bri_bers
bridlers11359183bridlers
briefers1335143briefers
briers85319733bri__ers
brimmers14287073brimmers
briners94315633bri_ners
bringers112811073bringers
brittler10165983brittler_
brittles10178653brittles
britts84813443britt__s
brothers133410823brothers
bruiters10329133bruiters
butters94521713_butters
canisters112310183canisters
canters94827723c_anters
carters95327243c_arters
casters94729893c_asters
caters85336493c__aters
cattery123811603c_attery
ceilers93912533cei_lers
centers94420593c_enters
centners1057243centners
cerites94823433ceri_te_s
chanters134016723chanters
chapters154012113chapters
charters134115563charters
chattels13286793chattels
chatter124416643chatter_
chattery16357273chattery
cheaters133613503cheaters
chiders135312943chi_ders
chiggers1535553chiggers
chillers133710913chillers
chimers144515133chi_mers
chippers173510873chippers
chirpers15358133chirpers
chittered15166413chittered
chitties13310773chitties
choristers1586093choristers
christens14125413christens
chunters133910893chunters
ciders94620083c_i_ders
cinders104617753c_inders
ciphers14379983c_iphers
circlers1235343circlers
cistern93310693c_istern
cisterns10369563c_isterns
citators10310233c_itators
citer74827323c_i_ter_
cites74435583c_i_te_s
cither114616683c_ither_
cithern12489913c_ithern
citherns13338863c_itherns
cities84524853c_itie_s
clatter94014973clatter_
clattery13378193clattery
clickers163910203clickers
climbers14318403climbers
clingers113810653clingers
clinkers14339833clinkers
clippers14368833clippers
clivers123411753cli_vers
cloisters1137413cloisters
clouters10399793clouters
clusters102912393clusters
clutter94211653clutter_
cluttery13346313cluttery
clysters13227823clysters
coasters104317303coasters
coaters93525773c_oaters
coilers93619903coi_lers
coiners93620753coi_ners
coinfers13349503coinfers
cointer93616723cointer_
colters93522433c_olters
cooters94525713c_ooters
copters113621273c_opters
costers94128303c_osters
cottars94412233c_ottars
cotter84926673c_otter_
cottiers10399153cottiers
coulters103614303coulters
counters103320183counters
courters103015363courters
couters93827283c_outers
coveters132411073coveters
cowriters14317273cowri_ters
crabbers14358743crabbers
crackers164111723crackers
cradlers11309183cradlers
crafter124111333crafter_
crammers14369343crammers
crappers144011023crappers
crashers134013223crashers
crater85026633cr_ater_
crates85736053cr_ate_s
cravers124416543cr_avers
crawlers13309003crawlers
creamers124111293creamers
creasers103612813creasers
creates95225173create_s
creators102814383creators
creepers12318623creepers
cribber13367663cribber_
cricketers1843883cricketers
crickets16418123crickets
crier74724463cri__er_
cries75438403cri__e_s
crimes105521583cri_me_s
crimmer133310773crimmer_
crimper136510423crimper_
cringer103514243cringer_
cringes103215503cringe_s
crinites10612753crinite_s
cripes105120873cri_pe_s
cripplers15314993cripplers
crises84529433cri_se_s
crispens12286253crispens
crisper113511053crisper_
criteria1047993cri_teria
critics112811093cri_tics
crits75527573cri_t__s
croakers14288503croakers
crofter12299573crofter_
crooners103911393crooners
croppers143311483croppers
crosiers103312053crosiers
crossers103912693crossers
croutes94815643croute_s
crowders14398793crowders
crowers124614893cr_owers
crowners133710743crowners
crozers184111083cr_ozers
croziers19287003croziers
cruisers10438263cruisers
crullers1047293crullers
crumbers14338223crumbers
cruppers14317313cruppers
crushers134010083crushers
cuittles1045903cuittles
curettes1039313curette_s
curites93919863curi_te_s
cutlers94216993c_utlers
cutter84520993c_utter_
dieters83216423_dieters
dithers114016153_dithers
dotters83715973_dotters
drafters12338523drafters
driers74516733dri__ers
drifter11348703drifter_
drillers9429713drillers
drinkers13277823drinkers
drippers13327933drippers
drivers114412793dri_vers
druthers1275793druthers
embitters13334723embitters
emitter93211083emitter_
erecters102611613erecters
fainters11349693fainters
fetters103517903_fetters
filters103816543_filters
fitter94120033_fitter_
flatters113814203flatters
flirters11337933flirters
flitter103413903flitter_
flutters114010813flutters
fraters103517203fr_aters
fretter103412753fretter_
friers94718933fri__ers
frillers11349863frillers
friskers15337373friskers
frites94922483fri_te_s
fritted113611333fritte_d
frittered13205163frittered
fritterer12234403fritterer
fritterers13203393fritterers
fritts94613193fritt__s
fritzes19329453fritze_s
frizers19329553fri_zers
frizzers19335103frizzers
frothers14279803frothers
frotteurs1242213frotteurs
fruiters11328173fruiters
gaiters83516533gai_ters
garotters1055033garotters
getters84216093_getters
gittern8337503_gittern
gitterns9326563_gitterns
glisters93912603glisters
glitter84211803glitter_
glittery12375613glittery
goiters84014433goi_ters
grafters12409183grafters
granters93614133granters
graters85419733gr_aters
greeters92610113greeters
gridders11286293gridders
grievers1255473grievers
grifter113810493grifter_
grillers93810803grillers
grinders103410423grinders
grinners9288043grinners
gripers104011463gri_pers
grippers13358123grippers
grister83915413grister_
gritted94110903gritte_d
grittier9316263grittier_
grouters95910063grouters
grunters9359023grunters
gutters83715503_gutters
hatters104221523_hatters
heisters113413133heisters
hinters103719573_hinters
hitter94419863_hitter_
hoisters113513473hoisters
imbitters13274503imbitters
inters64328043__inters
jilters144211953_jilters
jitter133314993_jitter_
jittery17346443_jittery
jointers15289323jointers
jotters143413803_jotters
keisters123212043keisters
kilters113813593_kilters
kiters105218583_ki_ters
kittens11347583_kittens
klisters123910483klisters
knitter11348133knitter_
knotters12276143knotters
kraters114212333kr_aters
krimmers16315673krimmers
leisters83312823leisters
letters73819853_letters
lifters104313773_lifters
linters73822613_linters
listers74026523_listers
liters65429873_li_ters
litter64324853_litter_
littery103710483_littery
loiters74116613loi_ters
lotters73921063_lotters
matters94421753_matters
meisters103313843meisters
milters93619083_milters
minters93822463_minters
misters93927503_misters
miters84328773_mi_ters
mithers123516733_mithers
mittens9349883_mittens
mutters94117133_mutters
natters73718063_natters
netters73618583_netters
niters64624203_ni_ters
nutters74215423_nutters
omitter9298503omitter_
orbiters1036593orbiters
orienters937613orienters
otters64021513__otters
painters103013023painters
patters94825193_patters
peripters1368123peripters
permitters1444623permitters
petters93722363_petters
philters1398173philters
pitiers93812653_pitiers
platters103415283platters
plotters104011553plotters
pointers103013723pointers
potters94024343_potters
praters94921643pr_aters
prattlers11195323prattlers
presters103419003presters
pricers113915063pri_cers
prickers163710673prickers
priers84521193pri__ers
primers114215673pri_mers
prinkers143010383prinkers
printer93917303printer_
printery13318433printery
prizers183911843pri_zers
putters94219183_putters
quieters17248733quieters
quilters17228433quilters
quitter162910753quitter_
quittors17155413quittors
rafters103715633_rafters
ranters73323643_ranters
rasters74629023_rasters
raters63936573_r_aters
rattens74213403_rattens
ratter64326313_ratter_
rattlers83510293_rattlers
reinters82614773reinters
remitters11328403remitters
renters74224813_renters
resters74130403_resters
reutters8138563reutters
ribbers113913183_ribbers
ribiers9319753_ribiers
ricers84120993_ri_cers
ridders93612483_ridders
riders74123903_ri_ders
rievers104311453_rievers
riflers103512193_riflers
riggers93613833_riggers
righters122610703_righters
rimers84522553_ri_mers
rimmers113812883_rimmers
ringers83922943_ringers
rinsers73815743_rinsers
rioter64817283_rioter_
rippers114115023_rippers
risers64624783_ri_sers
riskers114011993_riskers
rites54442553_ri_te_s
ritzes154812943_ritze_s
rivers94626543_ri_vers
riveters11228153_riveters
roisters83615543roisters
rooters74522933_rooters
rosters73727533_rosters
rotter64325463_rotter_
rottes64524833_rotte_s
routers74822853_routers
scatters103612753scatters
scribers12307953scri_bers
scrimpers1554633scrimpers
scripter12137773scripter_
scutters103311013scutters
setters73822063_setters
shatters113313903shatters
shifters14319853shifters
shutters113611333shutters
sifters103714783_sifters
sinters74024073_sinters
sisters73721573_sisters
sitter63323383_sitter_
skirters12337233skirters
skitter113810393skitter_
skittery15315103skittery
slithers114212953slithers
slitter73615873slitter_
slotters84012393slotters
smatters104011713smatters
smiters93414363smi_ters
smithers13369793smithers
snifters11318603snifters
spatters103914703spatters
spitter94015183spitter_
splitters11307323splitters
spotters104313373spotters
sprinters11329363sprinters
spritzers2043903spritzers
sputters104012863sputters
stinters83312743stinters
strutters955673strutters
stutters83210463stutters
suiters73618873sui_ters
swatters113911793swatters
swifters14277483swifters
swithers144310533swithers
swotters11448473swotters
tatters74520483_tatters
tetters74320473_tetters
tilters73315933_tilters
tinters74221103_tinters
titers64526403_ti_ters
titfers10318933_titfers
tithers104216733_tithers
titter63421163_titter_
totters74618733_totters
treaters83615823treaters
trickers143812813trickers
triers64321523tri__ers
triflers113110213triflers
triggers10257843triggers
trillers83613483trillers
trimers94615143tri_mers
trimeters1139203trimeters
trimmers12288913trimmers
trippers123210153trippers
triter65120593tri_ter_
trotter73312253trotter_
trusters83112243trusters
trysters11298363trysters
twisters11268173twisters
twitter10278093twitter_
twittery14303893twittery
uniters73814173uni_ters
ureters7311823ur_eters
utters63817113__utters
vetters104016313_vetters
waisters113811523waisters
waiters104218623wai_ters
wetters103817753_wetters
whetters14246653whetters
whitter139110893whitter_
whittlers1594333whittlers
winters103720473_winters
withers134417753_withers
wresters112711733wresters
wringers123110073wringers
writer94416513wri_ter_
writes94420333wri_te_s
writher134010853writher_
writhes134811703writhe_s
written10336343writte_n
yatters103914623_yatters
zithers193911973_zithers

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461624897.59319249.6
3Display Results4894890.1862629.0
 (SQL Overall)1786914897.94922479.7
 
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.