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

118 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
caissons103628(None) 
caisson936591caisson_
classons1037702classons
crimsons1245632crimsons
frissons1145042frissons
arsons63917213_a_rsons
basions94213953ba_sions
bassoons1036543bassoons
bassos85313703ba_sso_s
bisons83914373_bi_sons
cabezons2144543cabezons
caimans113811783cai_mans
cains75334303cai___ns
cairns85313303cai__rns
caldrons1138063caldrons
camions113916133ca_mions
campions143511293campions
cannons94412883ca_nnons
canons85522063ca__nons
cansos84915383ca_nso_s
cantons95221203ca_ntons
canyons124511593ca_nyons
capons104119503ca__pons
capstans1257243capstans
capstone1237653capstone
capstones1347373capstones
captions123813213captions
carassows1442933carassows
carbons115418943ca_rbons
cardons104519933ca_rdons
cardoons113411943cardoons
carillons1146353carillons
carrions10312443carrions
carryons1337103carryons
cartons94122473ca_rtons
cartoons104012803cartoons
caseins93115053ca_seins
caseous9312513ca_seous
caserns94711213ca_serns
cashoos12310793ca_shoos
casinos93512833casino_s
cassena9287843ca_ssena
cassenas10317483ca_ssenas
cassene93111543ca_ssene
cassenes103611293ca_ssenes
cassias93514343ca_ssias
cassina94113163ca_ssina
cassinas103610633ca_ssinas
cassine93817283ca_ssine
cassines103116613ca_ssines
cassino93512433ca_ssino
cassinos10309353ca_ssinos
cassis84818853ca_ss_is
cassock1545953ca_ssock
cassocks1645033ca_ssocks
castors94919433ca_stors
cations94524143ca_tions
cautions103313163cautions
cessions1039853cessions
chansons1337473chansons
chiffons1943693chiffons
chignons1444713chignons
chitons122611913chi_tons
chrismons1644003chrismons
cions75222853c_i__ons
ciscoes113610733c_iscoes
ciscos104711133c_isco_s
cissies94116153c_issies
cissoid1037343c_issoid
cissoids1145363c_issoids
cistrons102710623c_istrons
citrons92913223c_itrons
classon937693classon_
coitions10312843coitions
crimson1135643crimson_
crispens12286253crispens
cuisses9319883cuiss_es
cussos84210003c_usso_s
daikons12186693dai_kons
daimons10249323dai_mons
damsons1038013da_msons
elisions82210423elisions
emissions1146923emissions
fissions1138033_fissions
foisons1047613foi_sons
frisson1045313frisson_
gascons10289103ga_scons
gibsons1045043_gibsons
grisons838993gri_sons
lassoes74613853la_ssoes
lassos64913813la_sso_s
lessons73811013_lessons
lewissons1241743lewissons
liaisons844293liaisons
malisons1048773malisons
mansions1069793mansions
mascons113411583ma_scons
masons83916513ma__sons
missions10311903_missions
nasions73112383na_sions
omissions1146153omissions
orisons7310563ori_sons
paisanos10337553paisanos
paisans93614753pai_sans
parsons93516873pa_rsons
passions10310583passions
pistons93016373_pistons
poisons9310353poi_sons
prisons9313223pri_sons
raisins72715343rai_sins
ramsons939563ra_msons
scansions1145323scansions
scissions1145423scissions
scissors1054323scissors
unisons748423uni_sons
visions10311023_visions
waitrons1136633waitrons
warisons1136903warisons

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.1561145455.1
2DLD Change Limit1461621188.42317352.7
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.