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

148 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
rafted10471470(None) 
crafted13419771crafted
drafted12439031drafted
grafted124110221grafted
hafted134713831hafted
rafter94517581rafter
ranted74324701ranted
rated65441381ra_ted
ratted74923341ratted
rifted104115311rifted
wafted134012141wafted
acted88521732_acted
after85719792_after
anted66328242_anted
baffed154812172baffed
baited95319242baited
basted95227232basted
bated85935532ba_ted
batted95623652batted
bracted12410932bracted
canted94825782canted
carted98631442carted
catted95422472catted
crafter124111332crafter
crated94827772cra_ted
daffed14429492daffed
dafter104813342dafter
darted84620922darted
dated75530992da_ted
dauted84114932dauted
dawted11489682dawted
draftee11379522draftee
drafter11449422drafter
dratted9358592dratted
drifted12367952drifted
farted105121782farted
fasted105320952fasted
fated95632132fa_ted
fatted105419842fatted
fracted1339372fracted
gaffed144210202gaffed
gaited84416922gaited
gasted84821582gasted
gated75329772ga_ted
gifted114510702gifted
grafter114211152grafter
granted94715102granted
grated84523922gra_ted
grifted12379582grifted
hafter124815882hafter
halted105019602halted
hanted104124312hanted
hasted105125282hasted
hated95734022ha_ted
hatted104921512hatted
hefted134911422hefted
lasted74323602lasted
lated65240672la_ted
lifted104413522lifted
lofted103811892lofted
malted94819852malted
marted94425212marted
masted94025802masted
mated85537782ma_ted
matted94521412matted
naffed13408332naffed
orated74221502ora_ted
panted95024822panted
parted94228682parted
pasted94426902pasted
pated85237842pa_ted
patted94724682patted
prated94924922pra_ted
raced87635312ra_ced
racked134526082racked
radded94716492radded
raffled14429082raffled
raft76245912raft__
raftered1237662raftered
rafters103715632rafters
rafts87820632raft_s
raged74829452ra_ged
ragged94620262ragged
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
raked105831422ra_ked
rammed113117302rammed
ramped114617902ramped
ranged84824312ranged
ranked114620742ranked
ranter63826822ranter
raped85334622ra_ped
rapped114122682rapped
rared65738322ra_red
rased65033932ra_sed
rasped94715202rasped
raster64731442raster
rate45458762ra_te_
ratel54224882ra_tel
rater54943282ra_ter
rates55352012ra_tes
ratten64217382ratten
ratter64326312ratter
rattled84012952rattled
raved94931432ra_ved
raxed135622662ra_xed
rayed95127502ra_yed
razed155027982ra_zed
razeed163710012razeed
razzed15478282razzed
reacted103015712reacted
refed93921922ref_ed
refeed104717622refeed
reffed134712512reffed
refuted114313802refuted
rented74426592rented
rested74430782rested
retted74826312retted
riffed133811562riffed
rifled104115002rifled
rioted73416372rioted
roasted83912662roasted
rooted75424002rooted
rotted74524432rotted
routed75624332routed
ruffed134312742ruffed
rusted75020922rusted
rutted74518402rutted
salted74121202salted
sated66238532sa_ted
sauted74119602sauted
shafted14288802shafted
sifted104313672sifted
tarted74923372tarted
tasted74123972tasted
tatted74920532tatted
tauted75317112tauted
tufted10359282tufted
vatted104214732vatted
waffed16459792waffed
wafter124114612wafter
waited103819772waited
wanted104319722wanted
warted104223232warted
wasted104423022wasted
yaffed16457322yaffed

Search took 3 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.1231452772.4
2DLD Change Limit825511482.79629524.7
3Display Results1481480.0463217.4
 (SQL Overall)1786911482.96560266.8
 
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.