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

132 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
oeuvre93281(None) 
oeuvres1032831oeuvres
louvre9425682louvre
outre53922192o_utre
azure14911483azu_re
beaver114819253beaver
before11410153before
bemire103312803bemire
beware11313713beware
centre84316643centre
cere66741473ce__re
chevre14318313chevre
coenure968143coenure
colure8314153colu_re
cure66149123_cu_re
curve104920023_curve
cuvee10316143_cuvee
deave95022333deav_e
decare93919153decare
decurve1335583decurve
dekare112811563dekare
delve96018263delv_e
delver104913493delver
demure9311533demure
dere56845903de__re
desire7415303desire
deuce84517493deu_ce
dure56341813_du_re
eagre64315323_eagre
eave75733583_eav_e
elver85216243_elver
enure53520223_enure
ere36352773_e__re
euchre11137663_euchre
euro45325273_eu_ro
eve66331163_e_v_e
ever77027693_e_ver
eyre75525253_e_yre
fauve114712073fauv_e
fere76342233fe__re
feuar8310243feuar_
feuars938653feuars
fever115617953fe_ver
genre66016803ge_nre
heave114521813heav_e
heaver124819673heaver
helve115018093helv_e
here76447103he__re
inure54119053inu_re
keeve124512123keev_e
leave84723723leav_e
leaver94321513leaver
levee84023813le_vee
lever85125163le_ver
livre85613253_livre
louver94110393louver
louvred11354663louvred
louvres10356523louvres
lucre76415523_lucre
lure45142463_lu_re
manoeuvre14101433manoeuvre
maugre9308973maugre
mauve104013273mauv_e
meagre9349323meagre
mere67244443me__re
metre74821303me_tre
mure65941333_mu_re
murre74821073_murre
nerve86617373nerv_e
nervure1034973nervure
neume74414403neu_me
neuter63713793neuter
neve76224833ne_v_e
never86218643ne_ver
ochre103411593o_chre
ogive9379093ogiv_e
ogre56320743o__gre
olive84817153oliv_e
ombre94111793o_mbre
ordure756803ordure
ore36661833o___re
ounce77019933o_unce
ouphe104413263o_uphe
our36042893o_u_r_
ourie54027293o_urie
ours47237563o_u_rs
outer55633303o_uter
outvie92412793outvie
over77227343o__ver
ovule839493ovu_le
peeve104915253peev_e
pere66450263pe__re
pure65543333_pu_re
quare143920543_quare
quire144917123_quire
reave84528023reav_e
reaver94524733reaver
rebore86625643rebore
recurve1237403recurve
reeve84121323reev_e
refire95419473refire
rehire95415863rehire
reive85522943reiv_e
reiver95318293reiver
require16148653require
retire64927013retire
retore67630763retore
reuse56025363reu_se
revere94621253revere
revue81114453re_vue
rewire95421403rewire
rewore938030153rewore
secure8513533secure
sempre102710093sempre
sere46153473se__re
serve85425963serv_e
server94917713server
sever85426053se_ver
severe94016083severe
soever94412093soe_ver
square154513353square
squire155912453squire
sucre75019103_sucre
sure45447413_su_re
tenure6311613tenure
velure939773velure
venire93513693venire
verve115417723verv_e
weave115218533weav_e
weaver123916613weaver
weever123811443weever
were76238333we__re

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 Limit1127161326.36017722.6
3Display Results1321320.0334000.0
 (SQL Overall)1786911326.53327352.1
 
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.