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

107 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
inkpots133517(None) 
inkpot1237811inkpot_
ingots7912062in_gots
inkblots1442662inkblots
inputs837702in_puts
stinkpots1542622stinkpots
unknots1144302unknots
anklets114310413anklets
beknots1335083beknots
bowpots1446023bowpots
depots94716343_depots
despots10319683despots
enroots738713enroots
finfoots1444153finfoots
firepots1346893firepots
ginkgoes14323743ginkgoes
ginkgos13314183ginkgo_s
idiots768643i_diots
ikats95311153i_k_ats
ikons96311013i_k_ons
imports11309623i_mports
impost103011783i_mpost
imposts11269003i_mposts
inapt73522693inap_t_
incants92012803incants
incents92414533incents
incepts11238283incepts
incests92711383incests
incipits1246263incipits
incogs937903in_cogs
incross937663incross
indents83114663indents
indicts103210723indicts
indols74714203in_dols
indoors838553indoors
indows104210793in_dows
inducts10259573inducts
indults8289493indults
inept73622153inep_t_
inerts64517023in_erts
infants102210773infants
infects12279713infects
infests10279793infests
inflows1335523inflows
infos84311673in_fo_s
ingests83210983ingests
ingot61221063in_got_
inions64417003in_ions
injects16257453injects
inkblot1344203inkblot_
inkers104018833ink_ers
inkhorn1444363inkhorn
inkhorns1543583inkhorns
inkiest113415043inkiest
inkjet1737453inkjet_
inkles103515653ink_les
inkless11348713inkless
inks86926503ink___s
inkwood1584533inkwood
inkwoods1674083inkwoods
inlets63915573in_lets
inmost8411363in_most
inpour837063in_pour
inpours936423in_pours
input7314653in_put_
insects93710843insects
inserts74013993inserts
insets64016133in_sets
insists739083insists
inspans937803inspans
inspects1255863inspects
insults7268963insults
intents72115703intents
intorts7310973intorts
introits859713introits
introns73515023introns
intros64215773intro_s
intuits7310313intuits
invents102812053invents
inverts103211953inverts
invests10319683invests
isopods1045573isopods
jackpots2344003jackpots
kingpost1544423kingpost
kingposts1642803kingposts
knots95614723__knots
linkboys1742373linkboys
pinkoes135512313pink_oes
pinkos125313873pink_o_s
pinkroots1543353pinkroots
pinots85920273pin__ots
pots66452363___pots
reknots1136783reknots
repots85621003_repots
respots92912763respots
sexpots1636293sexpots
snoots64216683sn_oots
snots55225123sn__ots
spots74424113__spots
stinkpot1443633stinkpot_
sunspots1045083sunspots
teapots939053teapots
tinpot8312513tin_pot_
unipods1095703unipods
unknits1135553unknits
unknot1037413unknot_
unroots738563unroots

Search took 7 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.420425454.8
2DLD Change Limit1340271076.50020619.5
3Display Results1071070.0333242.4
 (SQL Overall)1786911076.95325699.8
 
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.