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

208 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
cloacas113623(None) 
cloaca1037261cloaca_
cloacae1145231cloacae
cloacal1135161cloacal
alpacas1137072alpacas
cacas95627982c__acas
clachs133511322cl_achs
clacks144516342cl_acks
cloaks124411262cloa_ks
clocks144916232clo_cks
coacts105314332c_oacts
coalas87418962c_oalas
cocas95926572c_o_cas
abacas104414723_abacas
albatas938373albatas
alohas9411703alo_has
alpaca1047383alpaca_
blacks144914953bl_acks
bloats85215763bloa_ts
blocks144513943blo_cks
blocs95219653blo_c_s
cabalas113516003cabalas
cabanas112413033cabanas
caca85528083c__aca_
cacao95420003c__acao
cacaos104616183c__acaos
calpacks18266523calpacks
calpacs133110343calpac_s
camas96333523c__amas
caracal11312513caracal
caracals12310763caracals
caracks152211563caracks
casabas1139983casabas
casas75327843c__asas
casavas1237823casavas
celiacs11157893celiac_s
celosias1048903celosias
chacmas1638003c_hacmas
charas114223613c_haras
chicas135916473c_hicas
chloasmas1642493chloasmas
choana1138443choana_
choanae1236863choanae
chocks174815313cho_cks
choices142010613choices
cholas114818003cho_las
chollas123811353chollas
choreas124414203choreas
cicadas1235993cicadas
cicalas1139303cicalas
clach124617823cl_ac_h
clachan1437183cl_achan
clachans1546413cl_achans
clack134720173cl_ac_k
clades94920463cl_ades
clads85722733cl_a_ds
clags85621123cl_a_gs
claims105211573cl_aims
clamps124515083cl_amps
clams95127673cl_a_ms
clangs95113613cl_angs
clanks124615183cl_anks
clans75031013cl_a_ns
claps95626183cl_a_ps
claros84015113cl_aros
clasps104512093cl_asps
class75525483cl_a_ss
clasts84817293cl_asts
claves115020063cl_aves
clavus11347353cl_avus
claws106020833cl_a_ws
clays105521333cl_a_ys
cleans85817053clea_ns
clears84116563clea_rs
cleats84919313clea_ts
cleaves124111623cleaves
clicks145315113cl_icks
clivias1266693clivias
cloak115214013clo__ak
cloaked14368543cloaked
cloche134312373clo_che
cloches144113713cloches
clock134917983clo_c_k
clods85320863clo__ds
clogs85519553clo__gs
clomps125212233clo_mps
clonal8310913clo_nal
cloners94514823cloners
clones84526563clo_nes
clonks125013473clo_nks
clons75228133clo__ns
clonus85212413clo_nus
cloots85113693clo_ots
clops95924853clo__ps
cloques18268563cloques
closers94415323closers
closes85425593clo_ses
closets94611603closets
clothes124513813clothes
cloths115512483clo_ths
clots75627643clo__ts
clouds94612353clo_uds
cloughs13517053cloughs
clours85215093clo_urs
clouts87017203clo_uts
clovers125114663clovers
cloves114918823clo_ves
clowns114810113clo_wns
cloys104916943clo__ys
clozes174915563clo_zes
clucks144512073cl_ucks
coach125919453c_oac_h
coaches144018693c_oaches
coact96130583c_oac_t
coala77521123c_oala_
coals76129603c_oa_ls
coapts104614013c_oapts
coasts85719143c_oasts
coatis85122603c_oatis
coats75635003c_oa_ts
coaxal15387303c_oaxal
coaxes154715633c_oaxes
cobias104014993c_obias
cobras104014193c_obras
coca88030643c_o_ca_
coccal9310223c_occal
coccus979283c_occus
cocks135227163c_o_cks
cocoas104915743c_ocoas
cocos95624693c_o_cos
codas84724243c_o_das
colas75436773c_o_las
colics104219903colic_s
colorcast1346553colorcast
colzas174010513c_olzas
comas95833003c_o_mas
commas124814573c_ommas
compas125817063c_ompas
conchas144013313c_onchas
conchs134714903c_onchs
congas94417033c_ongas
cooncan1147233cooncan
cooncans1246273cooncans
copras103517153c_opras
cottas84615573c_ottas
cracks144817003c_racks
croaks125812983croa_ks
crocks145118423cro_cks
crocs95722433cro_c_s
crocus104813173cro_cus
curacao1146293curacao
curacaos1244923curacaos
curacoas1246033curacoas
curaras93911953curaras
cycas126513823c__ycas
elodeas836963elodeas
flacks154114533fl_acks
floats96816253floa_ts
floccus1443653floccus
flocks154713533flo_cks
flocs105519233flo_c_s
floras94715693flo_ras
flotas94013003flo_tas
fracas11311993_fracas
glaces94218033gl_aces
glacis94012133gl_acis
gloams95210663gloa_ms
gloats74515423gloa_ts
glorias81610323glorias
glossas8438193glossas
koalas104011663_koalas
laces76141763_l_aces
lacks116129203_l_acks
lacs66942483_l_ac_s
lamas75532793_l_amas
lavas85422223_l_avas
lianas63713383_lianas
llamas888973_llamas
loach105116363_loac_h
loaches123613983_loaches
loads65323373_loa_ds
loafs85616993_loa_fs
loams75619863_loa_ms
loans56026463_loa_ns
loaves94813853_loaves
loca65527683_lo_ca_
local74820273_lo_cal
locals83714503_locals
lochs106715513_lo_chs
locks115126923_lo_cks
locos75822603_lo_cos
locus74819993_lo_cus
loofas9429833_loofas
lotas55926303_lo_tas
loumas84812333_loumas
maracas11313773maracas
ocas66729633__o_cas
orcas75918623__orcas
pacas96029403__pacas
patacas11311003patacas
places104323703pl_aces
placks144414153pl_acks
playas114612283pl_ayas
plazas17409913pl_azas
slacks124416533sl_acks
socas74026183_so_cas
solaces93116133solaces
ulamas8910453ul_amas

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272086.87319500.5
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.34324334.9
 
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.