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

400 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
caimans11381178(None) 
caiman103615661caiman_
caymans14349511caymans
atmans84413962_atmans
cabman123812502cabman_
caftans12179442caftans
cains75334302cai__ns
cairns85313302cai_rns
callans94518472callans
camas96333522ca_ma_s
camass104114182ca_mass
camions113916132camions
cancans11311872cancans
captans111612052captans
carman103920742carman_
cayman133613212cayman_
chairmans1685142chairmans
chimars144010592chimars
claimant1247482claimant
claimants1344282claimants
daimons10249322daimons
damans94715982da_mans
limans84816302_limans
paisans93614752paisans
saimins9312112saimins
taipans9269552taipans
acaridans1254033acaridans
acumens1136953acumens
adman84517903_adman_
admass957143_admass
agmas85919873_agma_s
aidman92410623_aidman_
aimers84621913_aimers
aiming94320843_aiming
aims67738183_aim__s
ains46158883_ai__ns
airman82414223_airman_
airns55521033_ai_rns
alans55636173_a_lans
almahs118611613_almahs
almas76629773_alma_s
amahs107819063_a_mahs
amas67746293_a_ma_s
amass77119683_a_mass
amens75624843_a_mens
amias75831473_amia_s
amins75534323_a_mins
animals94111703animals
animas84418723anima_s
atamans9710433atamans
atman75520143_atman_
atmas75721013_atma_s
avians93711563_avians
axman144813183_axman_
azans146516883_a_zans
badman113813843badman_
bagman114613813bagman_
bairns86710873bai_rns
baizas173810823baiza_s
banians9312033banians
banyans1237913banyans
barman103519703barman_
batman105214063batman_
bayman133712703bayman_
bimahs13508303_bimahs
bimas95521743_bima_s
cabals104020153ca_bals
cabana103913563ca_bana
cabanas112413033ca_banas
cabins104418923ca_bins
cabmen123610653cabmen_
cacaos104616183ca_caos
cacas95627983ca_ca_s
caeomas1138403caeoma_s
caesars9410733caesars
caftan111710123caftan_
caids85226423cai__ds
cain65643913cai__n_
caiques18248793caiques
cairds96411513cai_rds
cairn75717513cai_rn_
cairny11557823cai_rny
caissons1036283caissons
calamars1238133calamars
calamus1139243calamus
calcars11312653calcars
calkins133814873calkins
callan83619603callan_
callant94121223callant
callants104112143callants
callas84526753calla_s
calming123915973calming
calms95222353calm__s
calpacs133110343calpacs
calpains1239763calpains
camail10314833ca_mail
camails11311753ca_mails
camases114216343ca_mases
camels105217083ca_mels
cameos105818003ca_meos
cames97047313ca_m_es
camion103917193camion_
camisas113411923camisas
camises114218463camises
cammies134016483cammies
camos95927613ca_m_os
campos125217953ca_mpos
camps116330263ca_m_ps
campus125213923ca_mpus
cams87047283ca_m__s
canals84421673ca_nals
cancan10314103cancan_
canikins14219163canikins
cannas84518403canna_s
cannons94412883cannons
canons85522063ca_nons
cans65050853c___ans
cantals93919573cantals
cantons95221203cantons
canvas113813333canva_s
canvass12376873canvass
canyons124511593canyons
capelans1238013capelans
capias10318353capia_s
capitals12209453capitals
caplins113515993caplins
capons104119503ca_pons
capstans1257243capstans
captains121810573captains
captan101613343captan_
carats85929023ca_rats
caravans1338623caravans
carbarns1238563carbarns
carbons115418943carbons
carcass11310513carcass
cardigans1345163cardigans
cardons104519943cardons
careens94514703careens
carinas93622413carina_s
caritas93316963carita_s
carlins93921923carlins
carmen104019343carmen_
carmine112918483carmine
carmines123617873carmines
carns75937563ca__rns
carpals113414633carpals
cartons94122473cartons
casas75327843ca_sa_s
casbahs1436463casbahs
caseins93115053caseins
caserns94711223caserns
cashaws15398573cashaws
casitas93312043casita_s
casuals91410523casuals
catenas9313113catenas
caterans10313223caterans
cations94524143cations
catjang1733923catjang
catjangs1843223catjangs
catkins133012563catkins
catlins93818843catlins
catmint11314463catmint
catmints1236663catmints
catnaps1197033catnaps
causals91411183causals
caveats1239803caveats
caveman1437073caveman_
caverns124510253caverns
caviars1238623caviars
ceibas1038503ceiba_s
chacmas1638003chacma_s
chainman1585193chainman_
chains114819703chai__ns
chairman15106383chairman_
chapman1637893chapman_
chazans21268123chazans
chazzans21234503chazzans
chias104625523chi_a_s
chiaus113611313chi_aus
chicane1489553chicane
chicanes1559373chicanes
chicano1496873chicano
chicanos1595993chicanos
chicas135916473chica_s
chimar133911473chima_r
chimbs153910303chim_bs
chimers144515143chimers
chimes134922573chim_es
chiming153311833chiming
chimlas1437453chimlas
chimps155713663chim_ps
chinas115119403china_s
chins105631463chi__ns
chitins122713793chitins
chitons122611913chitons
cigars9910723c_igars
cions75222853c_i_ons
clachans1546413clachans
claimers12298743claimers
claiming13279303claiming
claims105211573claim__s
clamant11312433clamant
clans75031013c__lans
claypans1543873claypans
cleans85817053c_leans
climate11312833climate
climates12311973climates
climax1735653clima_x
climaxes1944613climaxes
climbs12498723clim_bs
climes104720003clim_es
coigns94410063coi_gns
coins75834553coi__ns
comas95833003c_oma_s
command14399213command
commands15318823commands
commas124814573comma_s
commons13311043commons
corbans11313173corbans
cotans81317923c_otans
cowman13910373cowman_
cremains1238693cremains
crimes105521583crim_es
crimine112413473crimine
crimini11258883crimini
criminis12257303criminis
criminy14268453criminy
crimps124613453crim_ps
crimsons1245633crimsons
cuirass934973cuirass
cumins103314933c_umins
cummins1358963cummins
currans9310613currans
cyans105714813c__yans
cymars13599153c_ymars
cymas126417883c_yma_s
daemons10269233daemons
daikons12186693daikons
daimen92210573daimen_
daimios1035753daimios
daimon9259713daimon_
daimones11208803daimones
daimyos1342813daimyos
daman84821163da_man_
damars93815003da_mars
damiana1046563damiana
damianas1155573damianas
dammars12308193dammars
damns84916923da_m_ns
desmans1039003desmans
diamins10312213diamins
divans104612393_divans
diwans105110373_diwans
dolmans10479683dolmans
firmans12238523firmans
gagman103811243gagman_
gains65729513gai__ns
gamas85431363ga_ma_s
gamays126310913ga_mays
gamins94420053ga_mins
gammas115714693gamma_s
gammons1237973gammons
gasman92911743gasman_
germans1079473germans
habitans1346623habitans
haemins122811403haemins
halmas117017893halma_s
hamals114816823ha_mals
hammals14409223hammals
hammams13386443hammams
hanumans1344953hanumans
harijans1845723harijans
harmins123716723harmins
hazans183411653ha_zans
hazmats2136603hazmats
hazzans18215783hazzans
hetmans12187593hetmans
humans112312433_humans
imams91511113__imams
japans1539823ja_pans
jasmins1637083jasmins
jawans1657843ja_wans
kaftans14185353kaftans
kaiaks937043kai_aks
kains96125643kai__ns
kalians11310183kalians
kanbans1337723kanbans
karmas123013733karma_s
lagans75717783la_gans
lallans74113533lallans
lamas75532793la_ma_s
lamias85020613lamia_s
laminas93615873laminas
lauans65113533la_uans
lawman11289053lawman_
layman113511303layman_
lemans85316393_lemans
ligans76817733_ligans
liman75921603_liman_
limas75627633_lima_s
limens84618033_limens
limns75718393_lim_ns
madman113712383madman_
magians10310753magians
magmas115512503magma_s
maidens10349663maidens
mailman1137733mailman_
maimers113813043maimers
maiming122912723maiming
maims96321793maim__s
mains75635113mai__ns
mamas95930773ma_ma_s
mammals10389273mammals
mammas94616403mamma_s
mammons1048513mammons
mannans93611523mannans
mans66354553___mans
maximals19325223maximals
maximins1944533maximins
naans55815253na__ans
naiads739013nai_ads
nairas6312783naira_s
origans839973origans
outmans92413283outmans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
pains75138283pai__ns
paisan84417073paisan_
paisana94010223paisana
paisanas10288873paisanas
paisano9429513paisano
paisanos10337553paisanos
paisas84317493paisa_s
parians93519733parians
partans94418283partans
pavans115715593pa_vans
pians75126963_pi_ans
pimas94725103_pima_s
pitmans11188743pitmans
primas104418103prima_s
ptisans9317363ptisans
radians83013823radians
raglans82410133raglans
ragman94013713ragman_
raias54631123rai_a_s
raiment9315413raiment
raiments1039903raiments
rains55140233rai__ns
raisins72715343raisins
raitas64417673raita_s
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
remans84823003_remans
romans84620243_romans
saigas74114293saiga_s
saimin8313663saimin_
sains55639973sai__ns
salmons93713263salmons
sampans112411003sampans
sarans64224433sa_rans
seitans73312303seitans
shaitans1136413shaitans
shamans123610903shamans
siamang1045333siamang
siamangs1144063siamangs
simars84916933_simars
simas75727553_sima_s
simians959203_simians
somans84619303_somans
taigas73712563taiga_s
tailfans1144553tailfans
tains54936323tai__ns
taipan82410663taipan_
talismans1143833talismans
tamals84116633ta_mals
tampans113310983tampans
tarmacs1138323tarmacs
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
taximan1635783taximan_
taxman15328613taxman_
titans63414913_titans
tomans85419133_tomans
unmans82211993_unmans
vanman1139793vanman_
wadmals1335513wadmals
wains86930873wai__ns
wangans1149503wangans
wanigans1244743wanigans
wigans104511703_wigans
witans93412933_witans
womans114613653_womans
yamens114010823ya_mens
yamuns11336513ya_muns
yasmaks1633653yasmaks
zaikais2042913zaikais
zamias174212923zamia_s

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340274006.07622058.4
3Display Results4004000.1432797.2
 (SQL Overall)1786914006.60927037.5
 
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.