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

165 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
embrue103653(None) 
embrued1235291embrued
embrues1136471embrues
embrute1145701embrute
imbrue1035151imbrue
embrace1388892embrace
embruted1344352embruted
embrutes1245182embrutes
embryo1363962embryo
emerge91510462emerge
imbrued1234692imbrued
imbrues1135502imbrues
imbrute1144912imbrute
imbue939482imb_ue
ombre94111802ombr_e
umbrae1038682umbrae
accrue1035823accrue
ambage11510603ambage
amble95924643amb_le
ambries111614543ambries
ambry123512103ambr_y
amerce10310513amerce
bemire103312803bemir_e
blue65328463__blue
brae65639113__brae
bree67241263__bree
brie65837903__brie
brume95817983__brume
brut66537963__brut
brute75321783__brute
brux136315273__brux
demerge11168023demerge
demure9311533demur_e
eagre64315323eagr_e
earbud936283earbud
ecarte84313503ecarte
ecru65819533e_cru_
ecrus75113863e_crus
eerie55228533e_erie
embalm1236653embalm
embank14346553embank
embar94011603emb_ar
embargo1243023embargo
embark14458523embark
embarked17205213embarked
embarks15337353embarks
embarred13174793embarred
embars103812883embars
embay123410603emb_ay
embayed1535443embayed
embays131408333embays
embed105014303emb_ed
embeds11377903embeds
ember95516803emb_er
embers104116183embers
emblaze2045773emblaze
emblem1237583emblem
embody1435033embody
emboli1037483emboli
embolus1135543embolus
emboly1336723emboly
emborder1345083emborder
embosk1464863embosk
emboss1087383emboss
embow1297563emb_ow
embowed15236903embowed
embowel14235343embowel
embower14267403embower
embows1396823embows
embraced15106673embraced
embracer1496463embracer
embraces14128863embraces
embrasure1352903embrasure
embroil1146613embroil
embrown1454793embrown
embruing1344523embruing
embryon1474063embryon
embryos1464093embryos
emcee9315943em_cee
eme55837183em___e
emerged11158213emerged
emerges101310883emerges
emeries91620023emeries
emerod9139213emerod
emersed10138513emersed
emery104814333emer_y
emeu66723433em_eu_
emeus76913333em_eus
emeute838533emeute
emigre937053emigre
emir65918703emir__
emirate91015833emirate
emirs76116163emir_s
emote75421193em_ote
empale102611263empale
empire1039323empire
emprise11310723emprise
emprize2038843emprize
emu55929983em__u_
emus66821683em__us
emyde1136383em_yde
endue64215353e_ndue
endure74014143endure
ensue54013833e_nsue
ensure63416003ensure
entree61817883entree
enure53520223enur_e
erbium1038083erbium
ere36352773e__r_e
erne46727423e__rne
estrum81810513estrum
estrus61912113estrus
eterne6311723eterne
exergue1544193exergue
extrude1545013extrude
eyre75525253e_yr_e
eyrie88117833e_yrie
fibre104812843fibr_e
grue55825713__grue
hombre13309303hombr_e
imbibe1234703imbibe
imbruted1343693imbruted
imbrutes1244203imbrutes
imbued1136173imb_ued
imbues1037983imb_ues
immure1036033immure
impure1038383impure
labrum1057423labrum
librae84310173librae
mare64759323_mar_e
marge85328333_marge
marque172410503_marque
marse76231153_marse
membrane1445653membrane
merde84320123_merde
mere67244443_mer_e
merge84523683_merge
merle75824373_merle
metre74821303metr_e
mire66748233_mir_e
morae75831193_morae
more67154523_mor_e
morgue938113_morgue
morse76032703_morse
moue65835573_m_oue
mure65941333_mur_e
murre74821073_murre
ombres103911143ombres
remarque1993553remarque
remerge10148923remerge
remorse9311713remorse
rue35549263___rue
sabre74821503sabr_e
sempre102710093sempr_e
sombre10729473sombr_e
sprue74717633_sprue
subdue9128493subdue
subrule939643subrule
timbre10328633timbr_e
true46725853__true
umbra948513umbr_a
umbrage1236723umbrage
umbral1038633umbral
umbras1038643umbras
untrue6310773untrue

Search took 7 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.1401276364.3
2DLD Change Limit1127161655.86019234.8
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.06329472.4
 
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.