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

172 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
conge8522759(None) 
cone67256961con_e
conga85419871conga
congee96024461congee
conger95024271conger
conges94928171conges
congo85623131congo
conte76633201conte
longe66626461longe
binge85125512binge
bone65949322bon_e
bong75633412bong_
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonne75124712bonne
bonze165119352bonze
cadge94018782cadge
cage75339062c_age
cane66653112can_e
cangue91012442cangue
canoe75627252canoe
cense75121402cense
change124116752change
cine66242942cin_e
clone75728162clon_e
coble94823172coble
code77347732co_de
codger105814842codger
cog69552902co_g_
cogged116416612cogged
cogs77340032co_gs
coign85013912coign
coigne94612192coigne
coinage10310552coinage
coke107038382co_ke
cole66956112co_le
comae97128422comae
combe116223542combe
come87547702co_me
comte96125472comte
con510268022con__
conch124620072conch
condo85322592condo
coned86040052coned
cones76457422cones
coney105932882coney
confer114018682confer
congaed11399742congaed
congas94417032congas
congeal104011682congeal
congeed113212312congeed
congees103517922congees
congers104223232congers
congest104618772congest
congii957362congii
congoes103617302congoes
congos94219882congos
congou94313242congou
coni65534802con_i
conic95329792conic
conies84338592conies
conin76232722conin
conine84528552conine
conk106531442con_k
conked135019112conked
conker124721552conker
conks115525702conks
conky145818742conky
conn66229132con_n
conned95119702conned
conner84423962conner
conns75024232conns
cons66057692con_s
contes84432912contes
conto76027172conto
conus76726532conus
convex18367742convex
convey144610222convey
cony96537832con_y
cooee74531022cooee
cope86847382co_pe
copse95623922copse
core67263112co_re
corgi8316082corgi
corse75036182corse
cosie74728262cosie
cote66648732co_te
coude85022632coude
cough115819642cough
coupe96023482coupe
cove95837072co_ve
cowage12310662cowage
coxae146115182coxae
cozie163519122cozie
cringe93515482cringe
crone75231332cron_e
dinge75627302dinge
dodge86618122dodge
doge66233802do_ge
done55747912don_e
donee66931012donee
dong66031652dong_
donga76718422donga
dongle83612492dongle
dongs76525812dongs
donne65520462donne
forge95126942forge
gone55639042gon_e
gong66827192gong_
gonged97115912gonged
gongs74921612gongs
gorge76423892gorge
gouge78220062gouge
henge94819822henge
hinge95323442hinge
hone77549322hon_e
hong85833952hong_
hongi96715852hongi
hongs95126202hongs
lodge76520082lodge
loge56837192lo_ge
lone45849132lon_e
long56933342long_
longed87121372longed
longer75823202longer
longes75925572longes
longs65527062longs
lounge75211212lounge
lunge65323802lunge
mange84930182mange
monde85723142monde
monger94418332monger
mongo810122412mongo
mongoe94214982mongoe
monie75631652monie
monte75829772monte
nonage7313682nonage
nonce75719822nonce
none45743172non_e
once65423082_once
one37050912_on_e
ponce95222512ponce
pone65747532pon_e
pong76231142pong_
ponged105619352ponged
pongee94920192pongee
pongs85526342pongs
range64728412range
rouge65423442rouge
sconce104711722sconce
scone74621832scon_e
singe65731132singe
sonde64622832sonde
sone46649982son_e
song55133672song_
songs67725552songs
sponge939662sponge
tenge65720432tenge
tinge64626612tinge
tone46953742ton_e
tong56434352tong_
tonga65619682tonga
tonged86518902tonged
tonger74719682tonger
tongs65928462tongs
tongue7410092tongue
tonne54921432tonne
venge95117982venge
wodge107212922wodge
zonae145116442zonae
zone135231082zon_e

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001721.65632487.9
3Display Results1721720.0463739.1
 (SQL Overall)1786911721.79599549.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.