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

155 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
boule7482804(None) 
bogle85821681bogle
bole66448691bo_le
boucle103712781boucle
boules84925971boules
boulle84614611boulle
bouse75931851bouse
joule124918201joule
bale66353842b_ale
bauble103813212bauble
baulk114914332baulk
belle75827832belle
bible95119412bible
bile66147172b_ile
birle75023632birle
blouse84714722blouse
blue65328462blu_e
blume95619892blume
bobble94115142bobble
bocce114313112bocce
boche124216952boche
bode75838752bo_de
boggle104511942boggle
bogie89524102bogie
bogles95020832bogles
boil66335182boil_
boiled95020952boiled
boiler84319272boiler
boils75427192boils
boite74426322boite
bola66035562bo_la
bold75432812bo_ld
boles75448602bo_les
boll65634752bo_ll
bolled94722652bolled
bolls75531312bolls
bolo65535952bo_lo
bolt66254172bo_lt
bolus79125542bolus
bombe115519312bombe
bone65949322bo_ne
bonne75124712bonne
bonze165119352bonze
boodle93215032boodle
booze164718912booze
bore66051332bo_re
borne77926792borne
botel75121862botel
bottle84916072bottle
boucles113113002boucles
bouffe14438312bouffe
bough115719312bough
bougie93613272bougie
boulder103411342boulder
boulles93114122boulles
bounce104014832bounce
bound84819582bound
bourg84113842bourg
bourn75518482bourn
bourne83714092bourne
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bout66353292bou_t
bouts75131312bouts
bowel105621202bowel
bowl96827702bowl_
bowled125018132bowled
bowleg12369172bowleg
bowler114217312bowler
bowls106121432bowls
bowse105420632bowse
boyla102912362boyla
brume95817982brume
brute75321782brute
bugle84721942bugle
bulb85626692b_ulb
bulge86419872b_ulge
bulk105426152b_ulk
bull65634872b_ull
bute66739672b_ute
butle75023102butle
ciboule1145092ciboule
coble94823172coble
cole66956112co_le
coude85022632coude
could86517712could
coulee8323502coulee
coupe96023482coupe
couple104415962couple
dole56550002do_le
double94013992double
douce85518422douce
doula65717772doula
douse66329722douse
foul77027582foul_
fouled104315972fouled
fouler93614902fouler
fouls87221432fouls
gouge78220062gouge
hole77553392ho_le
house89131422house
hoyle11314412hoyle
jole117233822jo_le
joules134116822joules
lobule82910062lobule
locule83412032locule
louie55023512louie
loupe75319512loupe
louse56131012louse
module93011032module
mole66251832mo_le
moue65835572mou_e
mould86015752mould
moult74728722moult
mouse77133002mouse
mule65236972_mule
noble74420992noble
nodule7309802nodule
obole75917142obole
ogle56325052_ogle
ole37155212_o_le
orle45630462_orle
ovule839492ovule
pole65951302po_le
poult76928872poult
pule65040952_pule
roble75223022roble
role45851822ro_le
rouble83913312rouble
roue45941742rou_e
rouge65423442rouge
rouse56634702rouse
route55132072route
rule49938422_rule
socle7419572socle
sole46053672so_le
soul46435712soul_
souled75419822souled
souls55127362souls
souse56530772souse
toile54626492toile
tole46052902to_le
touse55430672touse
tousle64514652tousle
touzle15429002touzle
tule45735872_tule
voile84719722voile
vole75236982vo_le
would95513152would
yodle94515042yodle
youse85322232youse
yule75725142_yule
zonule1577482zonule

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001551.75030742.9
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.88994595.6
 
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.