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

122 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
inkpot123781(None) 
inkpots1335171inkpots
inapt73522692inap_t
inept73622152inep_t
ingot61221062in_got
inkblot1344202inkblot
inkjet1737452inkjet
input7314652in_put
stinkpot1443632stinkpot
tinpot8312512tin_pot
unknot1037412unknot
anklet105618733anklet
antipot9312923antipot
beknot1239763beknot
bowpot13410073bowpot
depot85727923_depot
despot93413293despot
enroot6615993enroot
finfoot1347173finfoot
firepot1248733firepot
ginkgo12334943ginkgo_
ginkgos13314183ginkgos
idiot6718863i_diot
ikat87626643i_k_at
ikon85814953i_k_on
import102713763i_mport
impost103011783i_mpost
incant82418503incant
incent83320723incent
incept102712753incept
incest82918743incest
incipit1158923incipit
incog838253in_cog
incult82414773incult
indent73021243indent
indict93115573indict
indol63714873in_dol
indoor738403indoor
indow95011663in_dow
induct93212743induct
indult73614033indult
inert53234373in_ert
infant92315133infant
infect113413443infect
infest93315433infest
inflow1235293inflow
info75617353in_fo_
infos84311673in_fos
ingest73119003ingest
ingots7912063in_gots
inion54620183in_ion
inject153210233inject
ink76433633ink___
inkblots1442663inkblots
inked104218523ink_ed
inker94421093ink_er
inkers104018833inkers
inkhorn1444363inkhorn
inkier104013783inkier
inkiest113415043inkiest
inking115119053inking
inkle94515833ink_le
inkles103515653inkles
inks86926503ink__s
inkwood1584533inkwood
inky115321583ink__y
inlet53732403in_let
inmost8411363inmost
inpour837063in_pour
inputs837703in_puts
inro45920793in_ro_
insect83916583insect
insert64325253insert
inset54430863in_set
insist6314513insist
inspan837513inspan
inspect1138463inspect
insult62813673insult
intact8314663intact
intent63122773intent
into45026153in_to_
intort6418923intort
intro54915853intro_
introit7414533introit
intron64215023intron
intros64215773intros
intuit6314083intuit
invent93316363invent
invert94120083invert
invest93014843invest
isopod935913isopod
jackpot2245013jackpot
kingpost1544423kingpost
knot85630503__knot
linkboy1643173linkboy
mikvot1556763mikvot
not39474663_n__ot
pinkest132812623pinkest
pinko115618253pink_o_
pinkos125313873pink_os
pinkroot1445863pinkroot
pinot78737293pin__ot
pot58078433___pot
reknot10311733reknot
repot75132623_repot
respot83117633respot
sexpot1539543sexpot
snoot55030133sn_oot
snot44745443sn__ot
spot65540683__spot
stinkpots1542613stinkpots
sukkot936633sukkot
sunspot947163sunspot
teapot8416763teapot
unapt710421593unap_t
ungot61718063un_got
unipod946853unipod
unkent103116053unkent
unkept123710873unkept
unknit1068593unknit
unknots1144303unknots
unroot6315553unroot

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161224.97022679.3
3Display Results1221220.0462652.2
 (SQL Overall)1786911225.15634656.9
 
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.