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

170 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
clangors1141700(None) 
clangers114312341clangers
clangor10426681clangor_
clangours12263121clangours
candors104216762c_andors
cantors94620752c_antors
changers144313202changers
chantors133710262chantors
clamors11710092cla_mors
clanger104113492clanger_
clangored1343652clangored
clangorous1353312clangorous
clangour11293802clangour
clangs95113612clang__s
clingers113810662clingers
flangers123311372flangers
languors976152_languors
langurs889102_langurs
alastors8311203alastors
algors7312553__algors
angers75222543__angers
angora71111573__angora
angoras8811363__angoras
bangers104020353_bangers
blungers11469843blungers
cadgers114712003c_adgers
cagers95624193c_a_gers
cancers114018583c_ancers
candor94516423c_andor_
candours11408643c_andours
caners84629203c_an_ers
cangues10611823c_angues
cankers134418753c_ankers
canners93822663c_anners
cannons94412883c_annons
canoers94318373c_anoers
canoes84725883c_an_oes
canons85522063c_an_ons
cansos84915383c_anso_s
canters94827733c_anters
cantons95221203c_antons
cantor85621523c_antor_
cantos84826973c_anto_s
canyons124511593c_anyons
captors113914983c_aptors
cargoes104415223c_argoes
cargos94619183c_argo_s
castors94919443c_astors
censors93611843c_ensors
chadors1338753cha_dors
chancers154313493chancers
changer134215543changer_
changes134517583chang_es
changs125215373chang__s
chansons1337473chansons
chanters134016743chanters
chantor123710313chantor_
chargers144011323chargers
cilantros1142603cilantros
clabbers14359903clabbers
clackers163911703clackers
clags85621123cla_g__s
claimers12298743claimers
clambers144211293clambers
clammers143510693clammers
clamor1049453cla_mor_
clamours1255993clamours
clampers143211893clampers
clamworm1744203clamworm
clamworms1843753clamworms
clang86019313clang___
clanged114212653clang_ed
clanging124012123clanging
clangoring1443913clangoring
clangoured1441623clangoured
clanks124615183clan__ks
clans75031013clan___s
clappers143310833clappers
claquers19226203claquers
clarions10310493clarions
claroes93113733cla_roes
claros84015113cla_ro_s
clashers134213993clashers
claspers124410913claspers
classers104111833classers
classons1037703classons
clatters103313913clatters
claughts1443383claughts
clavers124314903cla_vers
claviers1367103claviers
clawers123910973cla_wers
claxons1635803cla_xons
claymore1544253claymore
claymores1644273claymores
cleaners103610543clean_ers
cleansers11335073cleansers
clinger103812153clinger_
clings95716213cling__s
clinkers14339833clinkers
cloggers12437283cloggers
cloners94514823clon_ers
clunkers14327553clunkers
coactors1239473coactors
coanchors1645733coanchors
colanders1238013colanders
condors104018573c_ondors
congers104223233c_ongers
congoes103617303c_ongoes
congos94219883c_ongo_s
congous103615083c_ongous
crankous1435973crankous
crannogs1143783crannogs
cringers112511873cringers
dangers94818213_dangers
flaggers13328073flaggers
flagons1137973fla_gons
flaneurs1133953flaneurs
flanger113412623flanger_
flanges113413273flang_es
flankers15349303flankers
flavors1337293fla_vors
flingers123410193flingers
gangers94418603_gangers
glamors1068113gla_mors
glancers11408003glancers
glanders103811503glanders
grangers103011973grangers
grantors93810353grantors
hangars114313493_hangars
hangers113120813_hangers
laagers83411253_laagers
labors84016413_la_bors
lagers74826143_la_gers
laggers94216243_laggers
lancers93616643_lancers
landers84026213_landers
langues81211913_langues
languor895423_languor_
langur7109303_langur_
lanners73618333_lanners
lanugos834453_lanugo_s
largos74815063_largo_s
lingers84223303_lingers
lingoes84014693_lingoes
llanos6108333llan_o_s
longers84819543_longers
lungers83817093_lungers
mangers103521263_mangers
mangoes104316133_mangoes
mangos94319333_mango_s
manors84420883_man_ors
olingos846013olingo_s
planers94517943plan_ers
planform1544753planform
planforms1643723planforms
planners10399933planners
planters102915323planters
playgoers1543193playgoers
pledgors12325263pledgors
plungers11379403plungers
quangos1734653quango_s
rancors9811373_rancors
rangers83621043_rangers
sangars83116253_sangars
sangers84421943_sangers
slanders94014013slanders
slangs75615343slang__s
slingers93712683slingers
tangos74216303_tango_s
twangers12226063twangers

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.420425454.8
2DLD Change Limit1461621707.51619446.8
3Display Results1701700.0802125.0
 (SQL Overall)1786911708.01622291.8
 
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.