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

138 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
cautious10311023(None) 
captious122810571captious
cautions103313181cautions
captions123813222captions
carious93320282ca_rious
cations94524142ca_tions
caution93013522cautio_n
cautiously1546522cautiously
curious93813562c_urious
factious13239242factious
incautious1243632incautious
nautilus844072nautilus
acanthous1444423acanthous
acaulous1045923acau_lous
acetous9410363acet_ous
actions94218513_actions
acuminous1344013acuminous
anxious1437283_anxious
auctions104012143_auctions
audios72312283_audio_s
aurous64119263_au_rous
autecious1145613_autecious
authors10311853_authors
autisms94311553_autisms
autists73814853_autists
autobus996513_autobus
autos56523323_aut_o_s
bastions10411693bastions
beauteous1143433beauteous
cachous14312583ca_chous
cactus104912233cact__us
caducous1344383caducous
caitiffs1642883caitiffs
callous93516603ca_llous
caltrops12307863caltrops
calumnious1443323calumnious
calutrons1145503calutrons
camions113916133ca_mions
campions143511293campions
canorous10310193canorous
cantdogs1244043cantdogs
canthus1248713cant_hus
cantinas102713783cantinas
cantons95221203cant_ons
cantors94620753cant_ors
cantos84826973cant_o_s
cantus85117763cant__us
capacious1546603capacious
capitols12247333capitols
caption113513693captio_n
captiously1746103captiously
captives1538623captives
captors113914983capt_ors
caribous1258823caribous
carrions10312453carrions
cartons94122473cart_ons
cartoons104012803cartoons
caseous9312513ca_seous
castings113614053castings
castors94919443cast_ors
cathouse1338863ca_thouse
cation83925503ca_tio_n
catties94023053catti_es
caucus1039613cau__cus
caudations13108223caudations
caudices13337343caudices
caulis85320083cauli__s
causations1268143causations
caustics1237483causti_cs
cautioned1245363cautioned
cautioner1145393cautioner
cautioners1244723cautioners
chitinous1474993chitinous
chutists1335583chutists
citrous93112993c_itrous
coactions1349743coactions
coauthors1444313coauthors
coitions10312853coitions
copious11311963c_opious
courteous1145813courteous
couscous1246683couscous
cretinous1145893cretinous
cuatros938273cuatro_s
cubitus11346783c_ubitus
cuprous1149743c_uprous
curios83218333c_urio_s
cuties84927363c_uti_es
cutins83919983c_uti_ns
cutis77723763c_uti__s
cutises94414913c_utises
cutout8315923c_ut_out
cutouts938033c_ut_outs
dauties83315763dauti_es
dubious1036893_dubious
duteous838453_duteous
elutions82513053elutions
facetious1464443facetious
factions133013063factions
fashious1446123fashious
fastuous1145143fastuous
fatuous1037783fa_tuous
fractious1456143fractious
furious103110633_furious
glutinous1044463glutinous
hautbois1343103hautbois
hautboys1642773hautboys
incautions1245973incautions
kations114013663ka_tions
lacteous1046783lacteous
luteous739273_luteous
manitous1039173manitous
muticous1246933_muticous
mutinous1047653_mutinous
nations74720563na_tions
nauseous844833nauseous
pactions122613503pactions
patios85221783pa_tio_s
patulous10116363patulous
pluvious1344443pluvious
rations74123433ra_tions
ratios64922673ra_tio_s
raucous938303rau_cous
recautions1247813recautions
rubious938283_rubious
ructious10277083ructious
sanious7514103sa_nious
sautoirs834923sautoirs
scabious1246593sca_bious
scarious10610203sca_rious
spurious1036963spurious
studious9245553studious
tactions102912423tactions
tautogs875413taut_ogs
tortious839023tortious
usurious845273usurious
various103113103va_rious
xanthous1846643xanthous
yautias1046333yauti_as

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.406440125.6
2DLD Change Limit1461621386.67321903.5
3Display Results1381380.0602300.0
 (SQL Overall)1786911387.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.