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 “calamanders” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
calamanders166290(None) 
calamander1553541calamander_
salamanders1462191salamanders
salamander1352862salamander_
alexanders1842443_alexanders
calamancoes1751813calamancoes
calamancos1652273calaman_cos
calamaries1446873calamarie_s
calamars1238133calama___rs
calamines13312223calamin_e_s
calamondins1652453calamondins
calenders1237403cal__enders
caravaners1544133caravan_ers
caravanners1652373caravanners
colanders1238013col__anders
commanders17146683c_ommanders
malanders1237023mal__anders
adamances1445034_adamance_s
alabasters1243254_alabasters
alamodes1148014_alam_ode_s
alexander1742774_alexander_
allemandes13143224allemande_s
almners9399564_al_m_n_ers
almoners1068134_al_mon_ers
amenders11288354___amenders
auslanders1143364_auslanders
backhanders23123804backhanders
balancers1345064bal__ancers
bilanders1235964bil__anders
calabashes1742904calabashe_s
calamanco1543114calaman__co
calamar1149294calama___r_
calamari1246114calama___ri
calamaris1346084calama__ris
calamary1545464calama___ry
calamatas1345784calama__tas
calamine12314034calamin_e__
calamined1447434calamin_e_d
calamints1348054calamin__ts
calamites13410714calam_ite_s
calamities1448474calamitie_s
calamondin1552664calamond_in
calcaneus1344164cal_can_eus
calendars1244524cal__endars
calender1138274cal__ender_
calmness1236644cal_m_n_ess
calumnies1346044calum_nie_s
capmakers1944724ca_pma_kers
carabineers1552504carabineers
carabiners1445064carabin_ers
carabiniers1552824carabiniers
caravaner1444734caravan_er_
caravanner1552634caravanner_
carmakers1736914ca_rma_kers
chamades16138654c_hama_de_s
chlamydes2062294chlam_yde_s
clamberers16174114c_lamberers
clambers144211294c_lam__bers
clammers143510694c_lam__mers
clamorers1345784c_lam_orers
clampers143211894c_lam__pers
clangers114312344c_l__angers
cleaners103610544c_l_ean_ers
cleansers11335064c_l_eansers
colander1139034col__ander_
coleaders1237824col_ea_ders
commandeers18123184c_ommandeers
commander16127404c_ommander_
commandery20134254c_ommandery
commenders17137144c_ommenders
corianders1344894c_orianders
coromandels1652064coromandels
cullenders1343194cul_lenders
cylinders1543204cyl__inders
demanders13247574__demanders
flatlanders1551984flatlanders
germanders1444604_germanders
glanders103811504_gl__anders
inlanders1036144inl__anders
islanders1035284isl__anders
lamenters1137684__lamenters
landers84026214__l__anders
launders9358744__la_unders
lavenders1334754__lavenders
mainlanders1462504mainlanders
oleanders1035574_ol_eanders
pomanders1436224__pomanders
relaunders1153104rela_unders
sarabandes1344084sarabande_s
slanders94014014_sl__anders
solanders1036964sol__anders
uplanders1234854upl__anders

Search took 10 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 Filter1786911488190.1731032896.0
2DLD Change Limit148819929.43615771.4
3Display Results92920.0462000.0
 (SQL Overall)178691929.65518507.6
 
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.