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

161 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
eureka103448(None) 
burka114617692bur_ka
euroky1334822euroky
urea46528062_ure_a
area45843393_are_a
areca75618633_areca
arena55323813_arena
arepa75615563_arepa
aura45836253aur__a
aurei54821863aure_i
aureola747033aureola
aures55137093aure_s
aureus65314883aureus
aurora6411763aurora
break115319403_break
bura66139533bur__a
bureau8712523bureau
buret77444013bure_t
burets84321263burets
burkas124513803bur_kas
burke115122763bur_ke
burked135220883burked
burker125221173burker
burkes124421313burkes
burqa165013093bur_qa
bursa74921523bur_sa
bursera936763bursera
creak115418433_creak
curara83712203curara
cure66149123cure__
cured85932133cure_d
curer75030753cure_r
curers84923193curers
cures75645433cure_s
curet75447643cure_t
curets84922343curets
curia74523773cur_ia
drek96321093_drek_
dreks105714753_dreks
dumka12438833du_mka
dura55232113dur__a
dure56341813dure__
dured75025403dure_d
dures65635923dure_s
duress74712063duress
durra65315793dur_ra
eared65139503eare_d
eczema1973073eczema
edema8610553e_dema
eek77935103e__ek_
egress73310433egress
egret63327313egre_t
egrets72712243egrets
enema7612743e_nema
entera64216833entera
enure53520223enure__
enured73315333enure_d
enures63919713enure_s
era35741503e_r__a
ere36352773e_re__
erect74129333e_rect
erica7316543e_rica
errata639013errata
erred65915673erre_d
eugenia847713eugenia
euglena843953euglena
eupnea835033eupnea
euripi856083euripi
euro45325273eur__o
euros54920243eur_os
euryoky1741813euryoky
excreta1674623excreta
extrema1675013extrema
exurbia1643443exurbia
eyra76217553eyr__a
eyre75525253eyre__
eyres84921773eyre_s
freak125115243_freak
frena85915273_frena
judoka18102583judoka
jura116024893jur__a
jurel124516333jure_l
jurels133710583jurels
kurta95113913kur_ta
lure45142463lure__
lured65427493lure_d
lurer54625313lure_r
lurers64217493lurers
lures56138533lure_s
lurex124816733lure_x
lurk86624163lur_k_
lurked114511973lurked
lurker103613293lurker
lurks95218743lur_ks
lutea54819073lute_a
marka114620793mar_ka
markka11416593markka
muleta839233muleta
mura65633303mur__a
mure65941333mure__
mured85726703mure_d
murein8311763murein
mures75937223mure_s
murex145517173mure_x
murk105527253mur_k_
murker123715243murker
murks114821733mur_ks
murky145216683mur_ky
murra74519083mur_ra
murrha11366453murrha
neuroma946523neuroma
neurula744373neurula
ocrea73311823ocre_a
ourebi837173ourebi
parka115120883par_ka
perea75026443pere_a
pereia85217983pereia
phreak1536153phreak
presa74319043_presa
pucka133412803pu_cka
pukka10457133pu_kka
punka114515483pu_nka
purana8712933purana
purda82914693pur_da
pure65543333pure__
puree74632843pure_e
pureed95017813pureed
purees84721683purees
purely114013633purely
purer75127903pure_r
purest84021933purest
quokka1841893quokka
screak125311063screak
streak104613623streak
sura45740293sur__a
sure45447413sure__
surely93816463surely
surer54833103sure_r
surest65026763surest
surety93515013surety
surra55521343sur_ra
trek86222313_trek_
treks96016853_treks
tureen63312723tureen
turk86125863tur_k_
turkey1337763turkey
turks95320823tur_ks
ulema7109713_ulema
urbia7311143_urbia
ureal56722683_ureal
ureas55826013_ureas
uredia73610063_uredia
uredo65112993_uredo
ureic74514463_ureic
uremia82910893_uremia
ursa44116913_ur_sa
uvea74712653_uve_a
weka117013873__weka
wreak125513273_wreak
yurta86014253yur_ta
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.390458182.1
2DLD Change Limit1127161615.17021801.9
3Display Results1611610.0463500.0
 (SQL Overall)1786911615.60631875.0
 
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.