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

208 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
urea4652806(None) 
area45843391area
ureal56722681ureal
ureas55826011ureas
ursa44116911ursa
uvea74712651uvea
are37874572are_
areae55229742areae
areal55928732areal
areas55935772areas
areca75618632areca
arena55323812arena
arepa75615562arepa
ares45871022ares
aria46245422aria
asea46327182asea
aura45836252aur_a
aurae54128112aurae
aurei54821862aurei
aures55137092aures
bra56339462br_a
brae65639112brae
bread85523112bread
break115319402break
bream95121812bream
bred75130972bred
bree67241262bree
bren65629562bren
brew95023562brew
bura66139532bur_a
bureau8712522bureau
buret77444012buret
burka114617692burka
burqa165013092burqa
bursa74921522bursa
creak115418432creak
cream95721352cream
cred76530882cred
crew96122682crew
cure66149122cure_
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curia74523772curia
dread74419022dread
dream85120392dream
drear65016902drear
dree56638322dree
dreg66821652dreg
drek96321092drek
drew86221672drew
dura55232112dur_a
dure56341812dure_
dured75025402dured
dures65635922dures
durra65315792durra
era35741502er_a
ere36352772ere_
eureka1034482eureka
flea75628492flea
frae75330472frae
freak125115242freak
free75940182free
frena85915272frena
fret75845042fret
great66034242great
gree56641562gree
grew85620262grew
grey85624042grey
idea59122772idea
ilea45931462ilea
ire36943172ire_
ired55131872ired
ires45639282ires
jura116024892jur_a
jurel124516332jurel
kea76540912_kea
kurta95113912kurta
lea37660182_lea
lure45142462lure_
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lutea54819072lutea
mura65633302mur_a
mure65941332mure_
mured85726702mured
mures75937222mures
murex145517172murex
murra74519082murra
ocrea73311822ocrea
odea56224572odea
olea46532722olea
ora37250832or_a
orca65522772orca
ore36661832ore_
oread64619602oread
ores46056682ores
orra46120722orra
pea56657242_pea
perea75026442perea
plea66830602plea
pree67044732pree
prep86427672prep
presa74319042presa
prex135722972prex
prey96228482prey
prez156126312prez
proa66229962proa
purda82914692purda
pure65543332pure_
puree74632842puree
purer75127902purer
re26153742_re_
read55942532_read
real45750292_real
ream65841612_ream
reap65934742_reap
rear45644552_rear
reb55844962_reb
rec55645462_rec
red46755802_red
ree37974072_ree
ref66053292_ref
reg46146492_reg
rei35647252_rei
rem56150042_rem
rep55847802_rep
res35565042_res
ret35982832_ret
rev65336622_rev
rex105740992_rex
rhea75017432rhea
ria36745502_ria
rue35549262rue_
rued55729792rued
ruer46127562ruer
rues46044482rues
ruga56121232ruga
rya67622012_rya
sea36161292_sea
sera46141392sera
shea76031572shea
sura45740292sur_a
sure45447412sure_
surer54833102surer
surra55521342surra
tea37353322_tea
toea46732332toea
tread64821702tread
treat56240352treat
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
uke75727292uke_
ukes86122812ukes
ulema7109712ulema
ulna46317332ulna
ulva75412692ulva
unread73412672unread
unreal64414452unreal
uprear8168792uprear
uraei53016082uraei
urb55731112ur_b
urban72013862urban
urbia7311142urbia
urbs65922062urbs
urd46427052ur_d
urds55922432urds
urease64516992urease
uredia73610062uredia
uredo65112992uredo
ureic74514462ureic
uremia82910892uremia
urge54722422urge
urged75316032urged
urger64116472urger
urges64619912urges
urial54823022urial
uric63624942uric
urn35731472ur_n
urns46323902urns
urp56426402ur_p
urped84615282urped
urps66920482urps
ursae55214452ursae
urus46426142urus
use36835162use_
used55722822used
user45023002user
uses44931112uses
usnea539392usnea
uta37425582u_ta
ute35335882ute_
utes45930882utes
uveal84411072uveal
uveas84912282uveas
vera76828842vera
wreak125513272wreak
wren78221682wren
yea66445752_yea
yurta86014252yurta
zoea137118422zoea

Search took 5 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.796224486.2
2DLD Change Limit298722082.68611121.4
3Display Results2082080.220945.5
 (SQL Overall)1786912083.70248268.8
 
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.