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

146 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
cambists143702(None) 
cambisms1645801cambisms
cambist13312111cambist_
ambits103713412_ambi_ts
cambism1538032cambis_m
cambiums1644932cambiums
camisas113411922cam_isas
camises114218462cam_ises
casuists1036522casuists
combusts1445502combusts
cubists11359022c_ubists
gambits12399722gambi_ts
lambasts12145622lambasts
ageists848493_ageists
agists75713173_a_gists
ambients1246053_ambients
ambit94223713_ambi_t_
amiss75823073_am_is_s
amorists10411333_amorists
aorists74215833_aorists
artists74215593_artists
assists738473_assists
aurists74615783_aurists
autists73814853_autists
babbitts1144023babbitts
bambinos1443873bambinos
baptists1236723baptists
bassists1037183bassists
bemists113410703bem_ists
bombasts1444943bombasts
cabalists1339153cabalists
cabbalists1644723cabbalists
cabbies133115163cabbi_es
cabinets1238283ca_binets
cabins104418923ca_bi_ns
cablets114216343ca_blets
caddises12329353caddises
camails11311753camai_ls
camases114216343cam_ases
camass104114183cam_as_s
camasses12388973camasses
cambers134017443camb_ers
cambia124913153cambi__a
cambial134010763cambi_al
cambium1537323cambi_um
cambrics1645253cambrics
camions113916133cam_ions
camisa103114323cam_is_a
camise103319633cam_is_e
camisia112810243cam_isia
camisias12268603cam_isias
camlets114314623cam_lets
cammies134016483cammi_es
camorrists1443723camorrists
campiest142212133campiest_
campings154010203campings
campions143511293campions
campouts1436823campouts
campsite1447413campsite
campsites1546473campsites
campuses1437773campuses
canoeists1147163canoeists
canonists1158513canonists
carbides133111693carbides
carbines123617533carbines
cassises103811743cassises
casts77237793ca___sts
casuist9411303casuist_
catbirds1344203catbirds
catboats1247873catboats
catmints1236663catmints
cellists1038563cellists
cembalists1645243cembalists
ceramists1346723ceram_ists
chamisas15317813cham_isas
chamises153513313cham_ises
chamisos15307423cham_isos
chamoises16327933chamoises
chartists14126803chartists
chemists152710323chemists
chutists1335583chutists
chymists18285603chymists
cists76624533c___ists
cladists1136723cladists
classists11296243classists
coassists11275763coassists
coexists1735653coexists
combats13311683comb_ats
combines142814623combines
combings15348323combings
combust1338363combust_
comfits14328743comfi_ts
commits133812383commi_ts
composts144210913composts
consists10310593consists
copyists1545993copyists
cosmists1237993cosmists
crampits1436273crampi_ts
cubisms13306883c_ubisms
cubist104214443c_ubist_
cubits103714033c_ubi_ts
cultists10107633cultists
cumbias13338963cumbi_as
cyclists1545713cyclists
cymbalists1944073cymbalists
czarists1966223czarists
dadaists1045583dadaists
faddists13235543faddists
fascists1336613fascists
fauvists1443843fauvists
gambias125010733gambi_as
gambiers13337073gambiers
gambirs12359083gambi_rs
gambit114714213gambi_t_
habits113014653ha_bi_ts
harpists1338103harpists
hymnists1644903hymnists
iambics13425643iambi_cs
iambuses1235783iambuses
imagists1175113imagists
lambast11129893lambast_
lambaste12145013lambaste
lambastes13114693lambastes
lamberts12348793lamberts
lambies113015113lambi_es
lambiest122410183lambiest_
maists85817573__maists
marimbists1652243marimbists
mists76633903__m_ists
narcists1078113narcists
palmists12268813palmists
papists112110453pa_pists
rabbits11299863rabbi_ts
racists92613323ra_cists
rapists92510753ra_pists
sacrists1039563sacrists
sadists83310853sa_dists
sumoists1046733sumoists
symbiots1573623symbiots
tabbises12236523tabbises
tachists1348183tachists
tamises92715973tam_ises
tanists7313653ta_nists
tubists9288323_tubists
vibists1256483_vibists
waists97415453wa__ists

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.1561145455.1
2DLD Change Limit1461621466.81021462.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.02925422.0
 
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.