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

121 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
caisson93659(None) 
caissons1036281caissons
classon937692classon
crimson1135642crimson
frisson1045312frisson
arson55118833_a_rson
basion84315853ba_sion
basso76017283ba_sso_
bassoon937613bassoon
bassos85313703ba_ssos
bison75716983_bi_son
cabezon2044663cabezon
caids85226433caids__
caiman103615663cai_man
cain65643913cai___n
cains75334303cains__
cairn75717513cai__rn
cajon144513903ca__jon
caldron1038153caldron
camion103917193ca_mion
campion133011413campion
cannon84514443ca_nnon
canon74725303ca__non
canso75019403ca_nso_
cansos84915383ca_nsos
canton85722993ca_nton
canyon114512033ca_nyon
capon95221873ca__pon
capstan1137903capstan
capstone1237653capstone
caption113513693caption
carassow1343253carassow
carbon104919043ca_rbon
cardon94120853ca_rdon
cardoon104813813cardoon
carillon1046963carillon
carrion9312673carrion
carryon1237033carryon
carton84522663ca_rton
cartoon94114463cartoon
casein83216453ca_sein
casern84713313ca_sern
cashoo11312253ca_shoo
casino84317553casino_
casinos93512833casinos
cassena9287843ca_ssena
cassene93111543ca_ssene
cassia83714763ca_ssia
cassina94113163ca_ssina
cassine93817283ca_ssine
cassino93512433ca_ssino
cassis84818853ca_ssis
cassock1545953ca_ssock
castor84418533ca_stor
cation83925503ca_tion
caution93013523caution
cession939813cession
chanson1238043chanson
chiffon1844053chiffon
chignon1344623chignon
chiton112612393chi_ton
chrismon1544643chrismon
cion613330923c_i__on
cisco95112133c_isco_
ciscos104711133c_iscos
cissoid1037343c_issoid
cissy104811073c_iss_y
cistron9299883c_istron
citron83112983c_itron
classons1037703classons
coition9314313coition
crimsons1245633crimsons
crispen11348203crispen
crissa837623criss_a
crissal937413crissal
crissum1144843crissum
cuisse8318333cuiss_e
cuisses9319883cuisses
cusso74912293c_usso_
cussos84210003c_ussos
daikon11217243dai_kon
daimon9259713dai_mon
damson938063da_mson
elision72311103elision
emission1047673emission
fission1038733_fission
foison948933foi_son
frissons1145043frissons
gascon9339723ga_scon
gibson935123_gibson
grison7310103gri_son
lasso55015683la_sso_
lassos64913813la_ssos
lesson64412043_lesson
lewisson1142023lewisson
liaison744473liaison
lissom837403_lissom
malison939693malison
mansion9611543mansion
mascon103612743ma_scon
mason74820183ma__son
mission9312743_mission
nasion63914083na_sion
omission1046533omission
orison6411663ori_son
paisan84417073pai_san
paisano9429513paisano
parson83817903pa_rson
passion9310883passion
piston83515923_piston
poison8312223poi_son
prison8514023pri_son
raisin62716923rai_sin
ramson8310463ra_mson
scansion1045693scansion
scission1045563scission
scissor994123scissor
unison649033uni_son
vision9311313_vision
waitron1036333waitron
warison1037083warison

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.406440125.6
2DLD Change Limit1340271216.31321230.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.76526414.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.