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

303 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
cautions10331318(None) 
captions123813221captions
cations94524141ca_tions
caution93013521caution_
cautious103110231cautious
actions94218512_actions
auctions104012142_auctions
bastions10411692bastions
calutrons1145502calutrons
camions113916132ca_mions
campions143511292campions
cantons95221202cant_ons
caption113513692caption_
captious122810572captious
carrions10312452carrions
cartons94122472cart_ons
cartoons104012802cartoons
cation83925502ca_tion_
caudations13108222caudations
causations1268142causations
cautioned1245362cautioned
cautioner1145392cautioner
cautioners1244732cautioners
coactions1349742coactions
coitions10312852coitions
cutins83919982c_uti_ns
elutions82513052elutions
factions133013062factions
incautions1245972incautions
kations114013662ka_tions
nations74720562na_tions
pactions122613502pactions
rations74123432ra_tions
recautions1247812recautions
tactions102912422tactions
ablutions1146603ablutions
abutilons1142963abutilons
acetins9313173aceti_ns
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
actuations1239293actuations
adaptions1245223adaptions
alations82518893alations
amnions93710913_amnions
amotions1069843amotions
anions64123033_a_nions
antlions839193_antlions
arcuations1249343arcuations
auction93412933_auction_
audios72312283_audio_s
auditions1078753_auditions
authors10311853_authors
autisms94311553_autisms
autists73814853_autists
autoing8314043_autoing
autos56523323_aut_o_s
autumns943763_autumns
auxins13129813_auxi_ns
avions94114393_a_vions
axions134713483_a_xions
basions94213953ba_sions
bastion9312473bastion_
batons85519423ba_t_ons
baudrons1135763baudrons
boutons9310783bout_ons
bunions92210473_bunions
buttons9310333_buttons
cabezons2144553cabezons
cabins104418923ca_bi_ns
caftans12179443caft_ans
cains75334303ca__i_ns
cairns85313303ca__irns
caissons1036283caissons
caitiffs1642883caitiffs
caldrons1138063caldrons
calkins133814873calki_ns
caltrops12307863caltrops
calutron1045553calutron_
camion103917193ca_mion_
campion133011413campion_
cannons94412883ca_nnons
canons85522063ca__nons
cantdogs1244043cantdogs
canteens1038573canteens
cantina93417253canti_na
cantinas102713783cantinas
canting104725903canti_ng
canton85722993cant_on_
cantors94620753cant_ors
cantos84826973cant_o_s
canyons124511593ca_nyons
capitols12247333capitols
caplins113515993capli_ns
capons104119503ca__pons
captains121810573captains
captans111612053capt_ans
captioned1445763captioned
captives1538623captives
captors113914983capt_ors
carbons115418943ca_rbons
cardons104519943ca_rdons
cardoons113411943cardoons
carious93320283ca_rious
carlins93921923carli_ns
carnations12311353carnations
carotins102315583caroti_ns
carrion9312673carrion_
carryons1337103carryons
carting104228283carti_ng
carton84522663cart_on_
cartoon94114463cartoon_
cartoony13377403cartoony
caseations1258303caseations
caseins93115053casei_ns
casinos93512833ca_sinos
cassations1276873cassations
cassinos10309353cassinos
casting104628343casti_ng
castings113614053castings
castors94919443cast_ors
cationic12310013ca_tionic
catkins133012563ca_tkins
catlins93818843ca_tlins
catties94023053catti_es
catting103922643catti_ng
caudation1269993caudation_
caudices13337343caudices
cauldrons1242973cauldrons
cauline92215603cauli_ne
caulis85320083cauli__s
causation1199523causation_
causing103614413causi_ng
caustics1237483causti_cs
cautionary1553923cautionary
cautioning1345723cautioning
cautiously1546523cautiously
cessions1039853cessions
champions18875783champions
chitins122713793chiti_ns
chitons122611913chit_ons
chorions13310663chorions
chuting132910733chuti_ng
chutists1335583chutists
cions75222853c___ions
cistrons102710643cistrons
citations11312503citations
citrons92913223c_itrons
clarions10310493clarions
clavations1546183clavations
coaction12310773coaction_
coalitions1247923coalitions
coauthors1444313coauthors
coition9314313coition_
conations111318903conations
cooptions13107763cooptions
cortins92421333corti_ns
cottons9312193c_ottons
countians1147333countians
coupons112710563cou_pons
cousins9516003cousi_ns
cratons94316033crat_ons
creations112614543creations
cretins93216423creti_ns
crotons93714373crot_ons
croutons1036753crout_ons
crucians1245293crucians
cuatros938273cuatro_s
cullions10219223cullions
cumins103314933c_umi_ns
curios83218333c_urio_s
curious93813563c_urious
cushions1335693cushions
cutdowns1443343c_utdowns
cuties84927363c_uti_es
cutin75022783c_uti_n_
cutis77723763c_uti__s
cutises94414913c_utises
cytons111710183c_yt_ons
daltons8310403dalt_ons
dauties83315763dauti_es
dauting93814763dauti_ng
dictions111812673dictions
dilutions10248583dilutions
durions839963_durions
editions9310403editions
eductions1268773eductions
elations83719123elations
elusions82610083elusions
elution72913823elution_
emotions10610283emotions
enations83316903enations
equations1839493equations
eruptions1146763eruptions
exactions1838923exactions
faction122613333faction_
factious13239243factious
fanions103713073fa_nions
fashions1437243fashions
fictions132410743fictions
fluxions1844423fluxions
fractions1449103fractions
fruitions12106113fruitions
fusions1039153_fusions
futons93911513_fut_ons
gabions102410053ga_bions
gluttons944273gluttons
grunions945353grunions
halations12312393halations
hautbois1343103hautbois
hautboys1642773hautboys
inactions1139323inactions
incaution1146583incaution_
incautious1243633incautious
kation104315683ka_tion_
lampions12277973lampions
latinos73613803la_tinos
lattins74115483latti_ns
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
lections102413843lections
locations112512743loca_tions
locutions11207063locutions
lotions74614763_lotions
mansions1069793mansions
martians103111613martians
martins93322063marti_ns
matins84527783ma_ti_ns
matrons93517633ma_trons
mattins93316143matti_ns
mentions10312893mentions
motions94215003_motions
moutons9410313mout_ons
mutons84314363_mut_ons
muttons949283_muttons
nasions73112383na_sions
natations91412493natations
nation64322803na_tion_
natrons73215663na_trons
nautilus844073nautilus
neutrons838293neutrons
notions74014483_notions
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
partons94620513part_ons
passions10310583passions
patins87528783pa_ti_ns
patios85221793pa_tio_s
patrons93818103pa_trons
paulins9312613pauli_ns
plutons938343plut_ons
portions10514413portions
potions93417423_potions
precautions1546553precautions
putons83515153_put_ons
rampions12248023rampions
ration64226013ra_tion_
ratios64922673ra_tio_s
ratoons73815473ra_toons
rattons73815323ra_ttons
rattoons8327513rattoons
reactions11711713reactions
recaution1148093recaution_
reunions837273reunions
ructions102811683ructions
rutins63818393_ruti_ns
sanctions1138873sanctions
satins64930483sa_ti_ns
saurians837763saurians
sautoirs834923sautoirs
scalations1239783scalations
scallions1145783scallions
scansions1145323scansions
sections102714703sections
solutions988883solutions
stations82415223stations
suasions838783suasions
suctions103012903suctions
taction93213023taction_
talions7314113ta_lions
tampions12358123tampions
tauons63412673tau__ons
tautens7317843taut_ens
tauting83316383tauti_ng
tautogs875413taut_ogs
taxations1636863taxations
tractions11511623tractions
tuitions838283tuitions
turions7311573_turions
unctions1039733unctions
unions64216753__unions
vacations141910553vacations
valuations1348783valuations
vocations141911423voca_tions
volutions12108393volutions
waitrons1136643waitrons
wanions104011373wa_nions
wantons103713013want_ons
yaupons12345683yau_pons
yautias1046333yauti_as

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.876203985.2
2DLD Change Limit1461623037.86018595.7
3Display Results3033030.1232463.4
 (SQL Overall)1786913038.85920170.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.