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

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

99 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
clanger10411349(None) 
changer134215541changer
clanged114212651clanged
clangers114312341clangers
clangor10426681clangor
clinger103812151clinger
flanger113412621flanger
anger66225872__anger
banger94423632_banger
blander103715162blander
blanker134612022blanker
blunger104112012blunger
cadger105013912c_adger
cager85229222c_a_ger
cancer104220922c_ancer
caner75334772c_an_er
canker124422522c_anker
canner84625982c_anner
canoer85121072c_anoer
canter85230112c_anter
chancer144215632chancer
change124116752change_
changed144214142changed
changers144313202changers
changes134517582changes
chanter123919732chanter
charger133914062charger
clabber134210112clabber
clacker153813772clacker
clagged12749232clagged
claimer11279882claimer
clamber133311742clamber
clammer134211792clammer
clamper134012992clamper
clang86019312clang__
clangors11417002clangors
clangour11293802clangour
clangs95113612clang_s
clanked143812252clanked
clankier14327082clankier
clapper134011862clapper
claquer18287352claquer
clasher124615512clasher
clasper113811862clasper
classer93614612classer
clatter94014972clatter
claver113816972cla_ver
clavier1239172clavier
clawer114512782cla_wer
clayier1248322clayier
cleaner93712302clean_er
cleanser10356322cleanser
clinged113310092clinged
clingers113810662clingers
clingier1155852clingier
clinker133811662clinker
clogger11438802clogger
cloner84418092clon_er
clunker13419452clunker
colander1139032colander
conger95024272c_onger
cranker133612792cranker
cringer103514242cringer
danger83722822_danger
flagger12469352flagger
flange103411972flange_
flanged123810842flanged
flangers123311372flangers
flanges113413272flanges
flanker143911292flanker
flinger113710512flinger
ganger83721462_ganger
glancer103710072glancer
granger93514212granger
hanger104023252_hanger
laager74312782_laager
lager65132862_la_ger
lagger85919832_lagger
lancer84319972_lancer
lander74028482_lander
langur7109302_langur
lanker104123002_lanker
lanner64920602_lanner
larger74417512_larger
linger75226002_linger
longer75823202_longer
lunger75720422_lunger
manger94325002_manger
planer84122652plan_er
planner93511622planner
planter94017802planter
plunger104211242plunger
ranger73925522_ranger
sanger74524562_sanger
slander84015442slander
slanged94112852slanged
slangier9117932slangier
slinger83413832slinger
twanger11327432twanger

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671993.37631893.1
3Display Results99990.0303300.0
 (SQL Overall)178691993.77947285.3
 
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.