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

168 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
longe6662646(None) 
conge85227591conge
lodge76520081lodge
loge56837191lo_ge
lone45849131lon_e
long56933341long_
longed87121371longed
longer75823191longer
longes75925571longes
longs65527061longs
lounge75211211lounge
lunge65323801lunge
allonge837022allonge
alone55732962alon_e
along65419492along_
binge85125512binge
blonde94813292blonde
blunge94311482blunge
bone65949322bon_e
bong75633412bong_
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonne75124712bonne
bonze165119352bonze
clone75728162clon_e
cone67256962con_e
conga85419872conga
congee96024462congee
conger95024272conger
conges94928172conges
congo85623132congo
conte76633202conte
dinge75627302dinge
dodge86618122dodge
doge66233802do_ge
done55747912don_e
donee66931012donee
dong66031652dong_
donga76718422donga
dongle83612492dongle
dongs76525812dongs
donne65520462donne
flange103411972flange
flong95815682flong_
flongs105010492flongs
forge95126942forge
gone55639042gon_e
gong66827192gong_
gonged97115912gonged
gongs74921612gongs
gorge76423892gorge
gouge78220062gouge
henge94819822henge
hinge95323442hinge
hone77549322hon_e
hong85833952hong_
hongi96715852hongi
hongs95126202hongs
klong105310402klong_
klongs11436602klongs
lance75126722lance
lane45153322lan_e
lang56637372lang_
langue71012172langue
large65325462large
ledge76519462ledge
lense54523432lense
leone55018822leon_e
liege65314432liege
linage7713402linage
line46965572lin_e
ling57447962ling_
linga66820812linga
linger75225992linger
lingo66022102lingo
lings67135772lings
lingy96925132lingy
lobe65535362lo_be
lode56240112lo_de
lodged913815702lodged
lodger86517682lodger
lodges86820142lodges
log46252682lo_g_
loges66534202lo_ges
logged96622942logged
logger86420002logger
loggie84011992loggie
loggy105714192loggy
logo57931762lo_go
logs57343112lo_gs
logy87025782lo_gy
loner55431032loner
longan75612362longan
longers84819532longers
longest84114952longest
longies82916552longies
longly10279602longly
looie55624242looie
loonie64216452loonie
loose56627682loose
lope65941922lo_pe
lore45850352lo_re
lose45144582lo_se
lotte54923852lotte
lough95118482lough
louie55023512louie
lounged9468242lounged
lounger84610212lounger
lounges84811352lounges
loungy10476832loungy
loupe75319512loupe
louse56131012louse
lovage1037352lovage
love75234762lo_ve
lowe75435312lo_we
lowse87219902lowse
lozenge1743242lozenge
luge55531642l_uge
lune47140492lun_e
lung55732492lung_
lunged85418272lunged
lungee75119812lungee
lunger75720412lunger
lunges76123422lunges
lungi65516052lungi
lungs65223882lungs
mange84930182mange
monde85723142monde
monger94418332monger
mongo810122412mongo
mongoe94214982mongoe
monie75631652monie
monte75829772monte
nonage7313682nonage
nonce75719822nonce
none45743172non_e
once65423082_once
one37050912_on_e
plunge93811052plunge
ponce95222512ponce
pone65747532pon_e
pong76231142pong_
ponged105619352ponged
pongee94920192pongee
pongs85526342pongs
range64728412range
rouge65423442rouge
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 Limit538001681.58034050.6
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.719103950.6
 
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.