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

123 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
spiry10501735(None) 
spicy125417711spicy
spiky146014111spiky
spiny104921301spiny
spire75828691spire
spirt75032951spirt
spry96819121sp_ry
airy75734152_airy
apery106517902apery
apiary113910382apiary
aspire8612122aspire
dairy97016302dairy
expiry1834652expiry
fairy115318282fairy
hairy115316832hairy
miry96326742_miry
pily96132732_pily
piny911838352_piny
pipy115421512_pipy
pirn67128372_pirn
pity96031932_pity
pixy166117762_pixy
pry85728052_p_ry
saury84317222saury
scary105222592scary
scry96017762s_cry
serry84824122serry
shily115222012shily
shiny115122142shiny
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533892shirt
shirty124312552shirty
sir35746672s_ir_
sire46150412s_ire
sirs44338332s_irs
sizy164816392s_izy
skiey125012892skiey
skirl96012912skirl
skirr94810542skirr
skirt95624662skirt
slily85820032slily
slimy105417422slimy
smirk116612742smirk
smirky15406942smirky
sorry84618252sorry
spacy125415622spacy
spar65433302spar_
spare75135562spare
spark114920892spark
sparky154511522sparky
sparry115111302sparry
spars75431542spars
spay96631662sp_ay
speir75315362speir_
speirs85013232speirs
sperm93216012sperm
sphery14318882sphery
spic85227432spi_c
spica94717942spica
spice95528812spice
spicery14499012spicery
spicey134414232spicey
spick134519072spick
spics94123242spics
spidery13308202spidery
spied85427712spied
spiel74623912spiel
spier75728032spier
spiers84421742spiers
spies76037622spies
spiff133616392spiff
spiffy17326222spiffy
spik105419712spi_k
spike114922842spike
spikey155411332spikey
spiks114117472spiks
spile75230082spile
spill74821162spill
spilt75532222spilt
spin66231302spi_n
spine76534422spine
spinny114510182spinny
spins75327982spins
spiral83715342spiral
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirit83519922spirit
spirts85317132spirts
spit65545082spi_t
spite75430662spite
spits74429552spits
spitz166017962spitz
spiv95917792spi_v
spivs105114242spivs
spivvy1733212spivvy
splay105816042splay
spore75428592spore
sport75935982sport
sporty115112492sporty
spray106720062spray
sprig85617742sprig
sprit76736402sprit
spumy124610362spumy
spur65321192spur_
spurn74815452spurn
spurry11429112spurry
spurs74621522spurs
spurt77227982spurt
spy86023742sp__y
stimy105114732stimy
stir45723242stir_
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
story86723032story
swirl84514142swirl
swirly12439242swirly
updry1135482updry
wiry106422832_wiry

Search took 5 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 Filter178691538000.1701051123.5
2DLD Change Limit538001233.64014780.2
3Display Results1231230.0631952.4
 (SQL Overall)1786911233.87346137.6
 
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.