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

112 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
bolloxed183447(None) 
bollixed1834481bollixed
bolloxes1736831bolloxes
balloted1189042balloted
bellowed14158602bellowed
billowed14137062billowed
bolled94722652boll__ed
bollixes1747202bollixes
bollox1548742bollox__
dolloped1234982dolloped
followed15146272followed
holloaed12157392holloaed
holloed113812752hollo_ed
hollooed12146492hollooed
hollowed15157022hollowed
lolloped1134462lolloped
allowed111610073_allowed
alloyed11158033_alloyed
balled94926893ball__ed
ballonet10314503ballonet
ballooned1245103ballooned
balloter1078893balloter
belled94626183bell__ed
bellied104314073bell_ied
bellower13159063bellower
beloved13188393b_eloved
billed94224903bill__ed
billeted1137643billeted
bilobed1235913b_ilobed
blooded11379803b_looded
bloomed12439433b_loomed
blooped12398543b_looped
blowed125016693b__lowed
boiled95020953boil__ed
boilover1344023boilover
bollard103210503boll_ard
bollix1538053bollix__
bollocks1636503bollocks
bolloxing1944773bolloxing
boloney1247763bo_loney
bolted94617803bo_l_ted
boobed114514873bo__obed
booed85127273bo__o_ed
boohooed1444433boohooed
booked135319503bo__oked
boomed115318133bo__omed
booted94822733bo__oted
boozed184813833bo__ozed
borrowed1465043borrowed
bosomed1238003bo_somed
bottomed1344663bottomed
bowled125018133bowl__ed
bowwowed1642173bowwowed
boxed154318613b___oxed
bulldozed2242233bulldozed
bulled94626493bull__ed
bulleted1138393bulleted
bullied104514813bull_ied
bullweed1444753bullweed
collaged12279963collaged
collared113211143collared
collated113615063collated
colleted113011653colleted
collided12309793collided
collied103316673coll_ied
collogued1344073collogued
colloid10312873collo_id
colluded12296453colluded
colored10313473co_lored
dolled83518073doll__ed
dollied93811143doll_ied
fallowed15127753fallowed
fellowed15136833fellowed
folioed1138033folio_ed
follower14137073follower
galloped12107143galloped
halloaed121510153halloaed
halloed113314913hallo_ed
hallooed12168773hallooed
hallowed15179493hallowed
helloed113512423hello_ed
hilloaed12136923hilloaed
hilloed113211293hillo_ed
hollaed11359853holl_aed
hollered1237603hollered
holloes103818193hollo_es
hollower14127393hollower
hulloaed12105803hulloaed
hulloed11369793hullo_ed
hullooed12135093hullooed
jollied15349273joll_ied
lolled74315823loll__ed
loxed135017053___loxed
mellowed14166923mellowed
pillowed14156383pillowed
poleaxed1854813poleaxed
polled94022003poll__ed
pollened1157773pollened
polluted1135433polluted
rolled74220243roll__ed
rollover1144453rollover
sallowed12149033sallowed
scolloped1443653scolloped
soloed74515743so_lo_ed
tallowed12157713tallowed
tolled73819033toll__ed
volleyed1543533volleyed
volvoxes2142243volvoxes
walloped14146833walloped
wallowed15148163wallowed
willowed15156763willowed
yellowed15185743yellowed

Search took 9 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.326548131.9
2DLD Change Limit1461621128.59317009.4
3Display Results1121120.0502240.0
 (SQL Overall)1786911128.96919923.2
 
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.