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

116 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
spinout931158(None) 
spinous9310441spinous
spinouts1036021spinouts
pigout9314612_pigout
pinot78737292_pino_t
rainout7314392rainout
slipout949082slipout
snout54530632s__nout
spigot9312602spigo_t
spinet85629752spin_et
spinoff1544932spinoff
spinor839942spino_r
spinors939422spinors
spinose937942spinose
spout75029632sp__out
sprout8419402sp_rout
acinous9310933acinous
bailout9414133bailout
burnout9310453burnout
dimout9414243_dimout
heinous1038853heinous
input7314653__input
knout95018263__knout
linocut997673_linocut
ominous949033ominous
payout11714653_payout
picot95031013_pico_t
pignut9311573_pignut
pigouts1037593_pigouts
pilot77435063_pilo_t
pilous84717753_pilous
pinole83218783_pinole
pinon76024533_pino_n
pinons86019943_pinons
pinots85920273_pinots
pint66963183_pin__t
pinup9612883_pin_up
pious74621273_pi_ous
pivot106523873_pivo_t
pout65752553_p__out
printout1048133printout
putout8315113_putout
rainouts846923rainouts
ruinous739763ruinous
runout6414873_runout
saint55147073sain__t
sanious7514103sanious
scout75031453s__cout
sellout7313583sellout
setout64719473s_etout
shout85433173s__hout
shutout1048533shutout
sickout1359373sickout
sinful938803s_inful
sinuous739063s_inuous
sinus55523853s_in_us
skinful1444193skinful
skint95629233skin__t
slipouts1044893slipouts
snoot55030143s__noot
snort54833753s__nort
snot44745453s__no_t
snouts64915873s__nouts
snouty9419953s__nouty
spent75532833spen__t
spigots1037793spigots
spilt75532223spi__lt
spin66231303spin___
spinach1435403spinach
spinage10289653spinage
spinal84915313spin_al
spinals93911863spinals
spinate93114813spinate
spindle103210093spindle
spindly13257383spindly
spine76534423spin__e
spined95423943spin_ed
spinel85317333spin_el
spinels94512443spinels
spines85132033spin_es
spinets94714813spinets
spinier93715163spinier
spiniest102813233spiniest
spinner93912263spinner
spinney12438923spinney
spinny114510183spin_ny
spinoffs1642773spinoffs
spinosity1444243spinosity
spins75327983spin__s
spinto8410663spin_to
spintos939133spintos
spinula9257903spinula
spinule9299993spinule
spiny104921303spin__y
spirant9814293spirant
spirit83519923spi_rit
spiroid10219823spiroid
spirt75032953spi__rt
spit65545083spi___t
splint85223283splin__t
sport75935983sp__ort
spot65540693sp__o_t
spouts85115113sp__outs
sprint84526793sprin__t
sprouts949983sp_routs
spumous1135853spumous
standout948663standout
stickout1476333stickout
stint57037663stin__t
stout57434053s__tout
suint55638183suin__t
surtout7411683surtout
turnout7410283turnout
urinous7310083urinous
vinous93914173_vinous
wipeout1287873wipeout

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271166.72019944.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.