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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
conger9502427(None) 
codger105814871codger
confer114018681confer
conge85227591conge_
congee96024471congee
congers104223231congers
conges94928171conges
conker124721551conker
conner84423961conner
longer75823201longer
monger94418331monger
tonger74719681tonger
anger66225872_anger
banger94423632banger
binger94923452binger
bonder95324782bonder
boner75133082bon_er
bonged105719602bonged
bonier84321992bonier
bonzer175313672bonzer
booger94816552booger
cadger105013912cadger
cager85229222c_ager
cancer104220922cancer
caner75334772can_er
canker124422522canker
canner84625982canner
canoer85121072canoer
canter85230112canter
censer84516582censer
center84421412center
changer134215542changer
cinder94119122cinder
clanger104113492clanger
clinger103812152clinger
clogger11438802clogger
cloner84418092clon_er
coaler84121712coaler
coater84329572coater
coaxer153912792coaxer
cobber124116842cobber
cocker144320392cocker
codder104416342codder
coder86134222co_der
codgers115113932codgers
coffer144112862coffer
cogged116416612cogged
coiler84421592coiler
coiner84323782coiner
coinfer12419392coinfer
cointer93616722cointer
colder95121852colder
colter84625092colter
comber125118502comber
comer95832692co_mer
concern113011962concern
concert113325222concert
concur10411102concur
condor94616972condor
cone67256962con_e_
coned86040052con_ed
cones76457422con_es
coney105932882con_ey
confers124120092confers
conga85419872cong_a
congaed11399742congaed
congas94417032congas
congeal104011682congeal
congeed113212312congeed
congees103517922congees
congener112412202congener
congest104618772congest
congii957362congii
congo85623132cong_o
congoes103617302congoes
congos94219882congos
congou94313242congou
conies84338592conies
conifer123212642conifer
conked135019112conked
conkers133721042conkers
conned95119702conned
conners94023112conners
conquer1838622conquer
conte76633202conte_
contes84432912contes
convert123721472convert
convex18367742convex
convey144610222convey
cooer74831012co_oer
cooker124722452cooker
cooler84824712cooler
cooper104221122cooper
cooter85128612cooter
coper95336092co_per
copier103722892copier
copper124321892copper
copter109822012copter
corder94322882corder
corer75538872co_rer
corker124720852corker
corner84625622corner
cornier93017092cornier
cosher114819902cosher
cosier84423752cosier
coster84331292coster
cotter84926672cotter
cougar958782cougar
cougher133711732cougher
counter94220152counter
couter84930222couter
cover105430772co_ver
cower104531772co_wer
cowier113616162cowier
coyer105222842co_yer
cozier173315142cozier
cringer103514242cringer
cunner83915002cunner
danger83722822danger
dinger85323672dinger
dodger95817052dodger
dogger95216782dogger
finger104920332finger
fogger114414782fogger
fonder104120062fonder
forger104820772forger
ganger83721462ganger
ginger84920032ginger
goner66025162gon_er
gonged97115912gonged
gorger86116982gorger
gouger86014362gouger
hanger104023252hanger
hinger104723332hinger
hogger114615082hogger
honer85332092hon_er
honker134117462honker
hunger104015202hunger
jogger154713162jogger
linger75226002linger
lodger86517692lodger
logger86420002logger
loner55431042lon_er
longe66626462longe_
longed87121372longed
longers84819542longers
longes75925572longes
lounger84610212lounger
lunger75720422lunger
manger94325002manger
mongers104217272mongers
onager739662_onager
pinger94324092pinger
ponder94521692ponder
ponged105619352ponged
pongee94920192pongee
ranger73925522ranger
ringer74526062ringer
roger64521412ro_ger
sanger74524562sanger
singer74227312singer
sonder73623522sonder
sponger1038522sponger
toner55336242ton_er
tonged86518902tonged
tongers84116012tongers
tonier65520712tonier
tonner64819202tonner
winger104125442winger
wonder103617812wonder
wonner95114442wonner
wronger11288822wronger
yonder103214132yonder
yonker134110852yonker
younger11387162younger
zinger163816702zinger
zoner144520342zon_er

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 Filter178691825510.343520965.0
2DLD Change Limit825511773.32624819.9
3Display Results1771770.0931903.2
 (SQL Overall)1786911773.76247498.9
 
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.