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

139 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
bossed9481653(None) 
bosses85925401bosses
boused95322881boused
bowsed125715971bowsed
bussed94717051bussed
dossed84516631dossed
mossed94818891mossed
tossed74215221tossed
based85331582b_ased
bashed126225702bashed
basked135218602basked
basses85428302basses
basset85225382basset
basted95227232basted
bested94922752bested
biased94012222biased
biassed10418702biassed
blessed10319492blessed
blissed10388372blissed
bloused104310642bloused
blowsed13449022blowsed
boasted104113742boasted
boated94221972boated
bobbed104315832bobbed
bobsled12297152bobsled
boded95124962bo_ded
bodied103814582bodied
boffed15369482boffed
bogged116019282bogged
boiled95020952boiled
bolled94722652bolled
bolted94617802bolted
bombed134113872bombed
bonded104719952bonded
boned85133242bo_ned
bonged105719602bonged
bonked135517312bonked
boobed114514872boobed
booed85127272bo_oed
booked135319502booked
boomed115318132boomed
boosted104111982boosted
booted94822732booted
boozed184813832boozed
bopped134413402bopped
bored85034302bo_red
borked135117292borked
boshes114721882boshes
bosker123813652bosker
bosket124919222bosket
bosomed1238002bosomed
boss65938342boss__
bossier93712422bossier
bossies94116832bossies
bossy105515972boss_y
bouse75931852bouse_
bouses84931782bouses
bowed114533422bo_wed
bowled125018132bowled
bowse105420632bowse_
bowses115718862bowses
boxed154318612bo_xed
brassed103612372brassed
browsed134511232browsed
bused85624492b_used
bushed124822382bushed
busied95117222busied
busked134917702busked
busses85023382busses
busted95123152busted
cessed94615612cessed
coshed124217542coshed
cosied94819882cosied
cosset84125862cosset
costed95623112costed
crossed105313892crossed
cussed94917122cussed
dissed85220172dissed
dosed76626912do_sed
dossel74813642dossel
dosser74417972dosser
dosses76126272dosses
doused84821162doused
dowsed115015012dowsed
embossed1344692embossed
fessed104515062fessed
flossed11388532flossed
fosse86119462fosse_
fosses96022082fosses
fussed104613802fussed
gassed85217632gassed
glossed94410072glossed
goosed86817032goosed
grossed93812252grossed
hissed104114452hissed
hoised105117432hoised
horsed105321082horsed
hosed95830982ho_sed
hosted105020342hosted
housed105624102housed
jessed144112302jessed
joshed174610902joshed
josses135117682josses
kissed114412852kissed
loosed75520892loosed
losses65925232losses
loused74822912loused
massed94421322massed
messed95018182messed
missed94423602missed
moshed124517492moshed
mosser84618272mosser
mosses85527682mosses
moused94423302moused
moussed10338912moussed
mussed94418902mussed
noised75416232noised
noosed75018012noosed
nosed65524552no_sed
noshed104413502noshed
passed94320942passed
pissed94816932pissed
poised94918472poised
posed85828412po_sed
posse74722272posse_
posses85128802posses
posset84923252posset
posted93722492posted
roosed75621592roosed
rosed65930342ro_sed
roused75426442roused
sassed76116172sassed
soused74822982soused
sussed75015532sussed
tosser64215662tosser
tosses65225392tosses
toused74122012toused
wissed104114642wissed
yessed104511162yessed

Search took 8 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 Filter178691825510.376475242.0
2DLD Change Limit825511397.31011292.9
3Display Results1391390.1261103.2
 (SQL Overall)1786911397.81222873.9
 
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.