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 “skirr” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
skirr9481054(None) 
shirr84716921shirr
skier95119591skier
skirl96012911skirl
skirrs10448191skirrs
skirt95624661skirt
birr66022352_birr
chirr105015902chirr
kier86526802_kier
kir76535672_ki_r
kirk76221562_kirk
kirn87123432_kirn
kirs85831732_kirs
shier85428942shier
shire84727132shire
shirk124817842shirk
shirrs94413172shirrs
shirt84533892shirt
siker95326032siker
sir35746672s_i_r
sire46150412s_ire
sirra54416322s_irra
sirs44338332s_irs
skerry13356102skerry
ski74925682ski__
skid95720912ski_d
skids104615322skids
skied104417752skied
skiers104713692skiers
skies95026832skies
skiey125012892skiey
skiff153612792skiff
skill94316722skill
skim105322492ski_m
skimo116312532skimo
skimp135411312skimp
skims114517182skims
skin85927522ski_n
skink85916852skink
skins94723462skins
skint95629222skint
skip105421742ski_p
skips115616602skips
skirls10449822skirls
skirred12347072skirred
skirret11278162skirret
skirter11338482skirter
skirts104111502skirts
skis84825282ski_s
skit85437522ski_t
skite95120042skite
skits94721852skits
skive124614112skive
skiver134612102skiver
skort94925632skort
slier54827242slier
smirk116612742smirk
spier75728032spier
spire75828692spire
spirt75032952spirt
spiry105017352spiry
stir45723242sti_r
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
swirl84514142swirl
whirr114611192whirr
yirr76513572_yirr

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 Filter178691538000.1101624463.6
2DLD Change Limit53800681.87328724.0
3Display Results68680.0164250.0
 (SQL Overall)178691681.99989390.2
 
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.