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

447 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
cottiers1039915(None) 
cotters94323431cott_ers
cottier93814171cottier_
bottlers103810012bottlers
cattier93317072cattier_
catties94023052cattie_s
clothiers1443422clothiers
coaters93525772coat_ers
colliers103613582colliers
colters93522432colt_ers
cooters94525712coot_ers
cooties93725732cootie_s
copiers114215962co_piers
copters113621272copt_ers
costers94128302cost_ers
cottagers12305372cottagers
cottars94412232cott_ars
cotter84926672cott_er_
couriers103213162couriers
courtiers1146682courtiers
couters93827282cout_ers
cutters94218952cutt_ers
cutties93118842cuttie_s
dotters83715972dott_ers
dottier83910922dottier_
hotties103016952hottie_s
jotters143413802jott_ers
lotters73921062lott_ers
mottlers10388182mottlers
otters64021512_ott_ers
potters94024342pott_ers
pottier93516492pottier_
potties93723542pottie_s
puttiers10288012puttiers
rotters74421392rott_ers
scotties1039732scottie_s
totters74618732tott_ers
attires72312953_attires
batters94626013batt_ers
battier93515713battier_
battlers104110973battlers
betters94422093bett_ers
bitters94920353bitt_ers
bittier94211663bittier_
blotters104110983blott_ers
blottier10336413blottier_
boaters93419233boat_ers
bolters94017803bolt_ers
booties94124613bootie_s
botchers153511543botchers
bothers124317753bo_thers
bothies12414783bothie_s
bottler94211883bottler_
bottles94216273bottle_s
bottomers1344353bottomers
bouviers1375003bouviers
bustiers103810043bustiers
butters94521713butt_ers
butties93217953buttie_s
cahiers123510673c_ahiers
canters94827723cant_ers
carriers103614203carriers
carters95327243cart_ers
cashiers13318883cashiers
casters94729893cast_ers
catbriers1344143catbriers
catchers153114053catchers
caterers102814393caterers
caters85336493c_at_ers
cattery123811603catt_ery
cattie85221013cattie__
cattiest103016333cattiest
cattiness112310633cattiness
centers94420593cent_ers
centners1057243centners
chatters134213933chatters
chattier1337513chattier_
chitters133711163chitters
chitties13310773chittie_s
chortlers14305663chortlers
citers85022973c_it_ers
cithers124315753c_ithers
cities84524853c_itie_s
cittern9339133citt_ern
citterns10318113citt_erns
clatters103313903clatters
claviers1367103claviers
clothier1335363clothier_
clouters10399793clout_ers
clutters103210343clutters
coachers154312293coachers
coalers94419333co_alers
coalier93416173coalier_
coasters104317303coasters
coatees93816533coat_ees
coater84329553coat_er_
coatings113811843coatings
coatis85122593coati__s
coatless1039693coatless
coaxers164311063co_axers
cobbers134114753co_bbers
cobbier133410163cobbier_
cobblers14359593cobblers
cockers153618333co_ckers
cockier154013623cockier_
codders114114443co_dders
coddlers12359163coddlers
coders95426973co__ders
codgers115113923co_dgers
codifiers1555343codifiers
codrivers1544863codrivers
coercers1237653coercers
coffers154112693co_ffers
cognizers2164423cognizers
coheirs1236753cohei_rs
coherers132310733coherers
coilers93619903co_ilers
coiners93620753co_iners
coinfers13349503coinfers
cointers103616403cointers
coirs75221053co__i_rs
coitions10312843coitions
colies84837053co_lie_s
colliders12298073colliders
collier93618153collier_
colliery13307363colliery
collies94326583collie_s
colorers10312183colorers
colter84625093colt_er_
comakers16339163comakers
combers134516613co_mbers
combiners15247943combiners
comers105328083co__mers
comethers1637433comethers
comfier1439163comfier_
comities12317783comitie_s
commies133718443commie_s
compeers143410013compeers
compilers1537053compilers
compliers1538293compliers
comtes106222813comt_e_s
confers124120093co_nfers
confiders1537483confiders
confiners1439953confiners
congers104223233co_ngers
conies84338593co_nie_s
conifers133611703conifers
conkers133721043co_nkers
conners94023113co_nners
connivers1436933connivers
conquers1938213conquers
considers1238933considers
containers1249903containers
contes84432913cont_e_s
continuers1247943continuers
contours1039613contours
contrivers1547243contrivers
cooers84324563co__oers
cookers134619463co_okers
cookies133719273cookie_s
coolers93522493co_olers
coolies93824963coolie_s
coonties10513793coontie_s
coopers114019483co_opers
cooter85128613coot_er_
cootie84223073cootie__
copers104629843co__pers
copier103722893co_pier_
copies104130303co_pie_s
coppers133519753co_ppers
copter109822013copt_er_
corbies113520113corbie_s
corders104520873co_rders
corers85231073co__rers
corkers134118853co_rkers
corkier133114303corkier_
corners94723313co_rners
cornier93017083cornier_
coroners104016223coroners
corries94026783corrie_s
cortices12615003cortices
cortinas102212423cortinas
cortins92421313corti_ns
corulers1039763corulers
coshers123618173co_shers
cosier84423753co_sier_
cosies84932153co_sie_s
costars94217993cost_ars
coster84331293cost_er_
costless10310003costless
costlier1038523costlier_
costrels1038933costrels
costumers1374853costumers
costumiers1442973costumiers
coteries10422703coterie_s
cotes76347843co_t_e_s
cottae84615703cottae__
cottager11306803cottager_
cottages113310493cottages
cottar84613813cott_ar_
cottas84615573cott__as
cottered112511733cott_ered
cottons9312193cott_ons
cotypes1437943cotype_s
couchers153513843couchers
coughers14399953coughers
coulters103614303coulters
counters103320183counters
counties10316273countie_s
couplers123311313couplers
courier93617873courier_
coursers104412293coursers
courters103015363courters
courtier1059313courtier_
couter84930203cout_er_
couther123914623couther_
couthier13218903couthier_
coutures10311973coutures
couturiers1243853couturiers
coverers132712123coverers
covers114627963co__vers
coveters132411073coveters
cowers114625533co__wers
cowier113616163co_wier_
cowpies143314283cowpie_s
cowries124218013cowrie_s
cowriters14317273cowriters
cozeners19297783cozeners
cozier173315143co_zier_
cozies174521413co_zie_s
craters95021883crat_ers
criers83918583c__riers
critters103511313critters
crofters13358893croft_ers
crosiers103312053crosiers
croupiers1334633croupiers
croziers19287003croziers
curriers103410753curriers
cuties84927363c_utie_s
cutlers94216993c_utlers
cutovers1335113cutovers
cutter84520993cutt_er_
cuttings11277613cuttings
cuttles93613923cuttle_s
ditties83116983dittie_s
dossiers9318043dossiers
doters74423913do_t_ers
dotier73917033do_tier_
dottels8327783dott_els
dotter74419343dott_er_
dottiest92611393dottiest
dottiness1058043dottiness
dottles83912283dottle_s
dottrels963493dottrels
emptiers1275193emptiers
fattier103513463fattier_
fatties103018203fattie_s
fetters103517903fett_ers
fitters104517743fitt_ers
flytiers14254483flytiers
footers104618333foot_ers
footier104115103footier_
footies103721543footie_s
footlers113910793footlers
forties104323863fortie_s
fosters104220093fost_ers
frontiers1254993frontiers
getters84216093gett_ers
goiters84014433goit_ers
goutier82612353goutier_
grottier9316673grottier_
gutters83715503gutt_ers
guttier83911103guttier_
guttlers9306923guttlers
hatters104221523hatt_ers
hitters104717583hitt_ers
hogties112813993hogtie_s
hooters104520463hoot_ers
hootier104915343hootier_
hosiers104212633ho_siers
hostlers113310483hostlers
hoteliers1245803hoteliers
hotter94720073hott_er_
hottie92514363hottie__
jettier14358693jettier_
jetties143613123jettie_s
jitters144314463jitt_ers
jolliers15357433jolliers
jolters143711993jolt_ers
joltier14318493joltier_
jostlers15357683jostlers
jotter134315633jott_er_
jottings16275193jottings
jutties143814003juttie_s
kitties113213623kittie_s
knotters12276143knott_ers
knottier12203983knottier_
kotowers1534313kotowers
letters73819853lett_ers
litters73422563litt_ers
loathers113310433loathers
lofters103912903loft_ers
loftier1037763loftier_
loiters74116613loit_ers
looters74419163loot_ers
lotter64025603lott_er_
lottery10389823lott_ery
lottes65322753lott_e_s
luthiers1135163luthiers
matters94421753matt_ers
metiers93312843_metiers
molters93816973molt_ers
mooters93818623moot_ers
mortisers1186163mortisers
mothers123717623mo_thers
mothier121910213mothier_
motlier92010583motlier_
mottes85523693mott_e_s
mottler94410343mottler_
mottles93415803mottle_s
mottoes93412193mottoe_s
mouthers133811303mouthers
mutters94117133mutt_ers
natters73718063natt_ers
nattier73614623nattier_
netters73618583nett_ers
nettier74211813nettier_
nettlers8307513nettlers
nittier73512243nittier_
northers1139333northers
notchers13279423notchers
noters64020993no_t_ers
noticers1035693noticers
notifiers1245023notifiers
nutters74215423nutt_ers
nuttier73112023nuttier_
oaters65029783_oat_ers
osiers63412793_o_siers
ostlers72911203_ostlers
others93918003_o_thers
ottars64112223_ott_ars
otter54423973_ott_er_
outers64230163_out_ers
outliers82610673outliers
oxters134813273_oxt_ers
partiers103514243partiers
patters94825193patt_ers
patties93425143pattie_s
petters93722363pett_ers
pettier94213613pettier_
pitiers93812653_pitiers
plotters104011553plott_ers
plottier10327263plottier_
plotties103111413plottie_s
poetisers1145303poetisers
poetizers2045103poetizers
porters93722703port_ers
portiere1038773portiere
portieres1138203portieres
posters93927993post_ers
posties93128813postie_s
pothers123818623po_thers
potpies113116173potpie_s
potsies93019483potsie_s
potteens10256793potteens
potter83926983pott_er_
potterers11218653potterers
pottery123011073pott_ery
pottiest102815973pottiest
pottiness1179693pottiness
pottles93816983pottle_s
potzers184010543po_tzers
pouters94221863pout_ers
poutier93215323poutier_
powters124015653powt_ers
putters94219183putt_ers
puttier93314503puttier_
putties94420023puttie_s
ratters74422473ratt_ers
rattier74015593rattier_
rattlers83510293rattlers
rentiers83311763rentiers
ritters74020613ritt_ers
rooters74522933root_ers
rootier74915393rootier_
rosters73727533rost_ers
rotifers1136043rotifers
rotter64325463rott_er_
rottes64524833rott_e_s
roturiers944553roturiers
routers74822853rout_ers
ruttier73412283ruttier_
saltiers83411953saltiers
scatters103612753scatt_ers
scattier10267583scattier_
scooters103511013scoot_ers
scoters93313793sco_t_ers
scottie937443scottie__
scouters103411303scout_ers
scouthers1445993scouthers
scutters103311013scutt_ers
setters73822063sett_ers
settlers8289023settlers
sitters74221543sitt_ers
slotters84012393slott_ers
snottier8217373snottier_
softies103414613softie_s
soldiers9277773soldiers
soothers113913433soothers
sootier73916603sootier_
sorters74221113sort_ers
sorties74126403sortie_s
souters74422583sout_ers
southers114214453southers
spotters104313373spott_ers
spottier10207303spottier_
swotters11448473swott_ers
tatters74520483tatt_ers
tattier74216243tattier_
tatties74120343tattie_s
tattlers8369693tattlers
tetters74320473tett_ers
tiers55526523___tiers
titers64526403__titers
titters74219613titt_ers
titties73617363tittie_s
tooters73818773toot_ers
tootlers8289503tootlers
toters65026363to_t_ers
totter65021463tott_er_
totterers9186813totterers
tottery10388483tott_ery
touters74018333tout_ers
triers64321523__triers
trotters83310233trott_ers
tutties73216473tuttie_s
twiers95410163__twiers
utters63817113_utt_ers
vetters104016313vett_ers
vomiters1337203vomiters
voters95017443vo_t_ers
wetters103817753wett_ers
wittier103910823wittier_
worriers11257813worriers
yatters103914623yatt_ers
zootier163611173zootier_
zosters163015403zost_ers

Search took 9 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.1561145455.1
2DLD Change Limit1461624478.12317993.6
3Display Results4474470.1732583.8
 (SQL Overall)1786914478.45221141.9
 
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.