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

165 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
spited9482044(None) 
sited65130741s_ited
skited114313471skited
sopited104211051sopited
spiced115218311spiced
spied85427711spi_ed
spiked134915551spiked
spiled94621991spiled
spined95423941spined
spired94921861spired
spirted103913071spirted
spite75430661spite_
spites84127331spites
spitted103912701spitted
suited74019421suited
aspired1068172aspired
baited95319242baited
cited84421952_cited
despited1248322despited
doited85016632doited
edited83913672edited
espied9359772espi_ed
evited104013142evited
exited144712522exited
flited104616582flited
gaited84416922gaited
kited105120092_kited
opiated1039482opiated
opined95113852opined
opted84914272op_ted
pated85237842_pated
pied75035362_pi_ed
piked125623312_piked
piled85232992_piled
pined85935322_pined
piped105123162_piped
pithed124615612_pithed
pitied94017252_pitied
pitted94319592_pitted
respited11410812respited
sailed74327762sailed
sained75424242sained
sainted84114242sainted
salted74121202salted
sated66238532s_ated
sauted74119602sauted
seated75131052seated
seined74023062seined
seised74218122seised
seized164313652seized
shied96125492shi_ed
shifted14359972shifted
shined104620782shined
shitted114212042shitted
shuted103913162shuted
sided74825952s_ided
sifted104313672sifted
silted74020012silted
siped84927682s_iped
sipped113720632sipped
sired66134282s_ired
site47052412s_ite_
sites56045432s_ites
sized155519242s_ized
skated114414872skated
skied104417752ski_ed
skirted12388612skirted
skite95120042skite_
skites104418032skites
skived14429892skived
slated75028312slated
sliced94416312sliced
slimed94915122slimed
sliped95417062sliped
slitted83513312slitted
smiled93716432smiled
smite75224862smite_
smiter83616412smiter
smites83921922smites
sniped94913482sniped
soiled73822472soiled
sooted73922582sooted
sopite84917712sopite_
sopites93817172sopites
sorted74523712sorted
sotted74121392sotted
spaced114517252spaced
spaded103816752spaded
spaed85522272sp_aed
spared95427482spared
spate74731582spate_
spates85028172spates
spathed134013182spathed
spatted104014142spatted
spayed124213612spayed
sped76031492sp__ed
speed85526622sp_eed
speiled104412122speiled
speired103811102speired
spewed125512332spewed
spicated13309902spicated
spice95528812spice_
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spider94516802spider
spiel74623912spi_el
spieled104811882spieled
spier75728032spi_er
spiered104412462spiered
spies76037622spi_es
spiffed16257102spiffed
spike114922842spike_
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spile75230082spile_
spiles84227912spiles
spilled103613622spilled
spine76534422spine_
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spire75828692spire_
spirea84015632spirea
spirem104214162spirem
spires84628112spires
spirited1148962spirited
spit65545082spit__
spital83813872spital
spits74429552spit_s
spitter94015182spitter
spitz166017962spit_z
spitzes1849172spitzes
spliced124310592spliced
splined105013112splined
splinted11369252splinted
spoiled104811352spoiled
spoked134413892spoked
spored94821792spored
sported104015432sported
spotted103713132spotted
spouted103412262spouted
sprinted113411162sprinted
sprite84421772sprite_
sprites94220332sprites
spritzed2044782spritzed
spued84918472sp_ued
spumed114711542spumed
spurted103111972spurted
stated75427832stated
stied65723032sti_ed
stilted83511472stilted
stinted82914192stinted
stiped94517072stiped
suite54829562suite_
suiter64121812suiter
suites63727402suites
swiped123811092swiped
swived133610632swived
toited74016752toited
united74421542united
waited103819772waited
whited134814082whited
wited94727142_wited

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.1101624463.6
2DLD Change Limit825511652.61031628.7
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.76664602.7
 
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.