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

124 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
befouled143468(None) 
befooled1434801befooled
befouler1343921befouler
befogged1643152befogged
befoul1137252befoul__
befoulers1443122befoulers
befouls1236052befoul_s
behowled1733462behowled
berouged1235322berouged
fouled104315972__fouled
baffled16418063baf_fled
batfowled1851953batfowled
beclouded1543503beclouded
bedaubed1443183bedaubed
bedotted1234983bedotted
beetled1038213be_etled
befallen1344033befallen
befitted14305723befitted
beflea1147123bef__lea
befleaed1454653befleaed
befool1137713befool__
befools1236433befool_s
before11410153befo_re_
befouling1534983befouling
befuddled1742003befuddled
begalled1236013begalled
begoggled1541713begoggled
beguiled1244443beguiled
begulfed1552603be_gulfed
behold1247343beho_l_d
behooved1743133behooved
behoved16205563beho_ved
belauded1244793belauded
belled94626183be__lled
belonged1235313belonged
beloved13188393belo_ved
bemoaned1335553bemoaned
bemocked1934073bemocked
bemused1236713be_mused
berobed1238233bero_bed
bescoured1444333bescoured
beshouted1544073beshouted
besmiled1335493besmiled
besotted1135843besotted
bespoused1443753bespoused
beuncled1334013beuncled
beveled133811123be_veled
bevelled14327793bevelled
bewailed1435343bewailed
bewormed16235443bewormed
bifocaled1742463bifocaled
bifold1237223bifo_l_d
biforked1842873biforked
biformed1643693biformed
biofouler1441893biofouler
biofueled1541753biofueled
bloused104310643b_loused
boiled95020953b__oiled
bolled94722653b__olled
boodled113410933b_oodled
boule74828043b__oule_
boules84925973b__oules
boused95322883b__oused
bowled125018133b__owled
broiled103811423b_roiled
decoupled15114283decoupled
defaulted1443313defaulted
defiled124013103def_iled
defoamed15356243defoamed
defocused16143533defocused
defogged1533783defogged
deforced15247373deforced
deformed15248263deformed
defueled1374513defueled
defused125211093def_used
defuzed21447043def_uzed
deloused1036973deloused
detoured1036513detoured
devoured1335723devoured
dewooled1333833dewooled
effulged1642013_effulged
effused1434143_effused
ensouled935833ensouled
ferruled1263923ferruled
feruled11318413fe_ruled
foaled104515963__foaled
foiled104618403__foiled
fooled104317823__fooled
fouler93614903__fouler
fowled133914093__fowled
insouled936113insouled
meoued9118533me_ou_ed
peopled1238483pe_opled
reboiled11349393reboiled
recoaled113111783recoaled
recoiled113613213recoiled
recouped13128663recouped
recoupled1496163recoupled
redoubled1343773redoubled
refelled122810163refelled
refiled114318653ref_iled
refilled12278673refilled
refluxed1954343refluxed
refocused15144653refocused
refold103812113refo_l_d
refolded1337063refolded
reforged13268703reforged
reformed14249603reformed
refound1157413refou_nd
refounded1435473refounded
refueled1286573refueled
refuged125410873ref_uged
refused115114443ref_used
refuted114313803ref_uted
rehoused1239613rehoused
reoiled84316853re_oiled
repolled11359623repolled
repoured1139563repoured
rerolled93010043rerolled
rerouted9311143rerouted
resoled84119283reso_led
retooled938473retooled
souled75419823__souled
unfoiled12249723unfoiled

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621246.67321903.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.88925938.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.