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

106 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
skeen9481740(None) 
keen84830411_keen
seen46943121s_een
sheen85023311sheen
skean94415621skean
skee85431471skee_
skeed105018981skeed
skeens103912911skeens
skees95023121skees
skeet95429181skeet
skein94814411skein
skene96118121skene
akee85936812akee_
akees96119242akees
akene95818662akene
been65335782_been
green65522142green
keef115830002_keef
keek75624972_keek
keel85729472_keel
keens95721182_keens
keep106329822_keep
keet85347342_keet
ken76343982_k_en
kern85326212_kern
peen65938082_peen
preen75925052preen
queen144312062queen
sateen63815012sateen
scene77220572scene
screen85216022screen
see35772262s_ee_
seed55549482s_eed
seek85935482s_eek
seel45042982s_eel
seem65438562s_eem
seep66540342s_eep
seer45547042s_eer
sees45361052s_ees
semen75724102semen
sen36058522s__en
sene46848052s_ene
seven84118312seven
sewn76124332s_ewn
sheens95116992sheens
sheeny124912192sheeny
sheep105321522sheep
sheer84726892sheer
sheet84836962sheet
shewn115715702shewn
siren54525822siren
skeane104611372skeane
skeans104512912skeans
skeeing12308852skeeing
skeets104513252skeets
skeg95316162sk_eg
skegs105011232skegs
skeins103911902skeins
skell94915832skell
skelm114211292skelm
skelp114211422skelp
skenes104616632skenes
skep105219352sk_ep
skeps115614252skeps
skew116218762sk_ew
skewed145610232skewed
skewer13519612skewer
skews125413802skews
skied104417752skied
skier95119592skier
skies95026832skies
skiey125012892skiey
skin85927532sk_in
sklent103614352sklent
skyed13529922skyed
skyey15537222skyey
skymen1535312skymen
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
smeek114912352smeek
sneer54919952sneer
sokemen1337052sokemen
spean74620512spean
speed85526622speed
speel74420762speel
speer74623902speer
spleen8310262spleen
steed66024942steed
steek95418002steek
steel55721992steel
steep76020702steep
steer55423862steer
stein54620542stein
stern55319122stern
sweeny12358842sweeny
sweep104715722sweep
sweer84918572sweer
sweet85330522sweet
sweven1235982sweven
syren85216742syren
teen45938202_teen
treen55622752treen
tween84413742tween
ween75835462_ween
wheen115016052wheen

Search took 2 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.313570897.8
2DLD Change Limit538001061.54634799.5
3Display Results1061060.0166625.0
 (SQL Overall)1786911061.87595301.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.