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

143 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
urge5472241(None) 
gurge75419781gurge
purge85324601purge
surge65027691surge
urged75316031urged
urger64116471urger
urges64619911urges
age47154332_age
are37874572ar_e
argle65421562argle
argue64818442argue
arse46539272arse
aurae54128112aurae
barge85631022barge
brae65639112brae
bree67241262bree
brie65837902brie
budge94619872budge
bulge86419872bulge
burg74930362burg_
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgle94815862burgle
burgs84924092burgs
burke115122762burke
burse75527252burse
cage75339062cage
cure66149122cur_e
curie74533032curie
curse75829142curse
curve104920022curve
dirge75117072dirge
doge66233802doge
dree56638322dree
dreg66821652dreg
dure56341812dur_e
edge65719662edge
ere36352772er_e
erg45531072erg_
ergo56420152ergo
ergs55523812ergs
erne46727422erne
forge95126942forge
frae75330472frae
free75940182free
froe75329992froe
fudge105315522fudge
furze176815812furze
gage65936102gage
gorge76423892gorge
gree56641562gree
grue55825712grue
gurged95513362gurged
gurges84716862gurges
gurgle83912472gurgle
huge86321652huge
ire36943172ir_e
judge144714152judge
large65325462large
loge56837192loge
luge55531642luge
lunge65323802lunge
lure45142462lur_e
mage75739122mage
marge85328332marge
merge84523682merge
mure65941332mur_e
murre74821072murre
nudge74616422nudge
nurse54420122nurse
ogre56320742ogre
ore36661832or_e
orgy85218002orgy
orle45630462orle
ourie54027292ourie
page76036102page
parge85831852parge
pree67044732pree
pure65543332pur_e
puree74632842puree
purged104918262purged
purger94717232purger
purges94421762purges
purse76028892purse
rage55742352rage
re26153742_r_e
ree37974072_ree
reg46146492_reg
roe36861072_roe
rube65532012rube
rude55632782rude
rue35549262_rue
rug46039152rug_
ruga56121232ruga
rugae65114762rugae
rugs56033682rugs
rule49938422rule
rune45236292rune
ruse45938932ruse
rye66032542_rye
sage55044592sage
sarge65531132sarge
serge64727462serge
spurge93711322spurge
sure45447412sur_e
surged84118882surged
surger74320092surger
surges73924592surges
surgy95118522surgy
targe65227092targe
tree47745812tree
true46725852true
ugh76520682u_gh
uke75727292u_ke
unbe65319272unbe
unde55825482unde
uraei53016082uraei
urare56322552urare
urase54624682urase
urate55432162urate
urb55731102ur_b
urbs65922052urbs
urd46427042ur_d
urds55922422urds
urea46528052urea
urgent73816042urgent
urgers73313622urgers
uric63624932uric
urine55026592urine
urn35731462ur_n
urns46323892urns
urp56426392ur_p
urped84615282urped
urps66920472urps
ursa44116902ursa
ursae55214452ursae
urus46426132urus
usage6410212usage
use36835162u_se
ute35335882u_te
verge93419832verge
wage84834082wage

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 Filter178691298720.0802233637.5
2DLD Change Limit298721430.89033564.0
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.000178691.0
 
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.