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

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

147 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
ourebi83717(None) 
ourebis936121ourebis
aurei54821862aure_i
oribi7311092o_ribi
ourari63413542ourari
aures55137093aure_s
aureus65314883aureus
burb85334673bur_b_
burbs95423493bur_bs
bureau8712523bureau
buret77444013bure_t
burets84321263burets
cubeb115814663cubeb_
cubebs12508683cubebs
curari84414403curari
curb86732223cur_b_
curbed114615873curbed
curber104517053curber
curbs94821653cur_bs
cure66149123cure__
cured85932133cure_d
curer75030753cure_r
curers84923193curers
cures75645433cure_s
curet75447643cure_t
curets84922343curets
dourer74215273doure_r
dourest8312943dourest
dure56341813dure__
dured75025403dure_d
dures65635923dure_s
duress74712063duress
ephebi1345083ephebi
eureka1034483eureka
euripi856083euripi
foreby1438633foreby
gourami1083803gourami
grebe85114943_grebe
hereby14468333hereby
houri85915253hour__i
humeri1138523humeri
jurel124516333jure_l
jurels133710583jurels
kouroi1036513kour_oi
krubi1136523_krubi
loured74617403loure_d
lure45142463lure__
lured65427493lure_d
lurer54625313lure_r
lurers64217493lurers
lures56138533lure_s
lurex124816733lure_x
mure65941333mure__
mured85726703mure_d
murein8311763murein
mures75937223mure_s
murex145517173mure_x
oared65030653oare_d
obeli73711933o_beli
obi57127733o___bi
ocrea73311823ocre_a
ocreae83310273ocreae
ogre56320743ogre__
ogres65818633ogre_s
ogress7529503ogress
oorali6311263oorali
orb55736863o_r_b_
orbed85516193o_rbed
orbit73622063o_r_bit
orbs66626253o_r_bs
orby97519603o_r_by
ore36661833o_re__
oread64619603o_read
ores46056683o_re_s
oribis838833o_ribis
orrery936783orrery
our36042893our___
ourang73311063ourang
ouraris73512933ouraris
ourie54027303our_ie
ours47237563our__s
ourself1057453ourself
ousel55222403ouse_l
ousels64815283ousels
outbeg938733outbeg
outbid91411863ou_tbid
outby10411533ou_tby
outeat62824533outeat
outed65429063oute_d
outer55633303oute_r
outers64230173outers
outre53922203outre__
outread82811093outread
ouzel144612323ouze_l
ouzels15408703ouzels
overbid132710273overbid
overbig13237543overbig
poured95116743poure_d
pourer84516043poure_r
pourers93513673pourers
prebid113512843_prebid
pure65543333pure__
puree74632843pure_e
pureed95017813pureed
purees84721683purees
purely114013633purely
purer75127903pure_r
purest84021933purest
puri65931443pur__i
rarebit948423rarebit
reb55844963__reb_
rebid85121363__rebid
rebs65733563__rebs
rei35647253__re_i
soured74921863soure_d
sourer63620213soure_r
sourest7515713sourest
sure45447413sure__
surely93816463surely
surer54833103sure_r
surest65026763surest
surety93515013surety
surimi839103surimi
terebic1137983terebic
toured74216153toure_d
tourer64115073toure_r
tourers73512743tourers
turbid979713tur_bid
turbit8715113tur_bit
turbo71015043tur_bo
tureen63312723tureen
uraei53016083_uraei
urari54619963_urari
urb55731113_ur_b_
urbia7311143_ur_bia
urbs65922063_ur_bs
urea46528063_ure_a
ureal56722683_ureal
ureas55826013_ureas
uredia73610063_uredia
uredo65112993_uredo
ureic74514463_ureic
uremia82910893_uremia
uremic103410513_uremic
uretic82914353_uretic
uteri51012983_uteri
zareba1736423zareba

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161475.43620735.1
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.85830503.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.