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

206 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
clangor1042668(None) 
clanger104113491clanger
clangors11417001clangors
clangour11293801clangour
candor94516422c_andor
cantor85621522c_antor
changer134215542changer
chantor123710312chantor
clamor1049452cla_mor
clang86019312clang__
clanged114212652clanged
clangers114312342clangers
clangored1343652clangored
clangours12263122clangours
clangs95113612clang_s
clinger103812152clinger
flanger113412622flanger
languor895422_languor
langur7109302_langur
alang66023513alang__
alastor739653alastor
algor6513053__algor
anger66225873__anger
angora71111573__angora
banger94423633_banger
blander103715163blander
blanker134612023blanker
blunger104112013blunger
cadger105013903c_adger
cager85229223c_a_ger
calando1037383calando_
cancer104220923c_ancer
candors104216763c_andors
candour104210243c_andour
caner75334773c_an_er
cangue91012443c_angue
canker124422523c_anker
canner84625983c_anner
cannon84514443c_annon
cannot83616773c_annot
canoe75627253c_an_oe
canoer85121073c_anoer
canon74725303c_an_on
canso75019403c_anso_
cansos84915383c_ansos
canter85230113c_anter
canto74931013c_anto_
canton85722993c_anton
cantors94620753c_antors
cantos84826973c_antos
canyon114512033c_anyon
captor104914603c_aptor
cargo85322073c_argo_
cargos94619183c_argos
castor84418533c_astor
censor84011283c_ensor
chador1238673cha_dor
chancer144215633chancer
chang115418563chang__
change124116753chang_e
changed144214143changed
changers144313203changers
changes134517583changes
changs125215373chang_s
chanson1238043chanson
chanter123919733chanter
chantors133710263chantors
charger133914063charger
cilantro1042673cilantro
clabber134210113clabber
clacker153813773clacker
clag75924573cla_g__
clagged12749233clagged
clags85621123cla_g_s
claimer11279883claimer
clamber133311743clamber
clammer134211793clammer
clamors11710093cla_mors
clamour1196333clamour
clamper134012993clamper
clamworm1744193clamworm
clan65633923clan___
clanging124012123clanging
clangoring1443913clangoring
clangorous1353313clangorous
clangoured1441623clangoured
clank114719523clan__k
clanked143812253clanked
clankier14327083clankier
clanks124615183clan_ks
clanky15469073clan_ky
clans75031013clan__s
clapper134011863clapper
claquer18287353claquer
clarion9311663clarion
claro75018693cla_ro_
claros84015113cla_ros
clasher124615513clasher
clasper113811863clasper
classer93614613classer
classon937693classon
clatter94014973clatter
claught1335103claught
claver113816973cla_ver
clavier1239173clavier
clawer114512783cla_wer
claxon1536583cla_xon
clayier1248323clayier
claymore1544253claymore
cleaner93712303clean_er
cleanser10356313cleanser
cling86424673cling__
clinged113310093clinged
clingers113810663clingers
clingier1155853clingier
clings95716213cling_s
clingy12659063cling_y
clinker133811663clinker
clogger11438803clogger
cloner84418093clon_er
clung86013603clung__
clunker13419453clunker
coactor1139123coactor
coanchor1545253coanchor
colander1139033colander
condor94616973c_ondor
conger95024273c_onger
congo85623133c_ongo_
congos94219883c_ongos
congou94313243c_ongou
cranker133612783cranker
crannog1044243crannog
cringer103514243cringer
cyano105512493cyan_o_
danger83722823_danger
flagger12469353flagger
flagon1037983fla_gon
flaneur1034183flaneur
flange103411973flang_e
flanged123810843flanged
flangers123311373flangers
flanges113413273flanges
flanker143911293flanker
flavor1236663fla_vor
flinger113710513flinger
ganger83721463_ganger
glamor958183gla_mor
glancer103710073glancer
granger93514213granger
grantor84010933grantor
hangar104114513_hangar
hanger104023253_hanger
laager74312783_laager
labor75117313_la_bor
lager65132863_la_ger
lagger85919833_lagger
lancer84319973_lancer
lander74028483_lander
lang56637383_lang__
langue71012173_langue
languors976153_languors
langurs889103_langurs
lanker104123003_lanker
lanner64920603_lanner
lanugo735573_lanugo_
lanugos834453_lanugos
larger74417513_larger
largo65319783_largo_
largos74815063_largos
linger75226003_linger
lingo66022113_lingo_
llano5910603llan_o_
llanos6108333llan_os
longer75823203_longer
lunger75720423_lunger
manger94325003_manger
mango85724323_mango_
mangos94319333_mangos
manor78023933_man_or
olingo736933olingo_
olingos846013olingos
planar84212713plan_ar
planer84122653plan_er
planform1544753planform
planner93511623planner
plantar9369993plantar
planter94017803planter
playgoer1443533playgoer
pledgor11334993pledgor
plunger104211243plunger
quango1636493quango_
quangos1734653quangos
rancor8810373_rancor
ranger73925523_ranger
sangar73617683_sangar
sanger74524563_sanger
slander84015443slander
slang66324023slang__
slanged94112853slanged
slangier9117933slangier
slangs75615343slang_s
slangy105411393slang_y
slinger83413833slinger
tango66921173_tango_
tangos74216303_tangos
twanger11327433twanger

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.1401276364.3
2DLD Change Limit1340272067.03019065.0
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.25024647.0
 
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.