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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

89 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
inti4662608(None) 
anti45536361anti
intis55121641intis
into45026151into
ani37751182an_i
ant37270792ant_
anta46839582anta
ante46538902ante
antic75728862antic
antis55033312antis
ants47243472ants
bindi85617022bindi
binit76431582binit
bint67355052bint_
bints76130182bints
dint56759062dint_
dints67431312dints
entia5318202entia
hint77455752hint_
hints87330622hints
ictic9311802ictic
impi85415792impi
in28150872in__
inby95315662inby
inch95420822inch
indie63721472indie
indri6310792indri
infix15337772infix
info75617352info
inia45024702inia
ink76433642in_k
inks86926502inks
inky115321582inky
inly75622212inly
inn36727442in_n
inns46920932inns
inro45920792inro
ins35945612in_s
instil61111382instil
inter55028492inter
intima81910032intima
intime81014272intime
intine61021982intine
intro54915852intro
intuit6314082intuit
iota45127832iota
it28455692i_t_
its35538842i_ts
jinni125310632jinni
knit85728152knit
lati46438272lati
lint416266242lint_
lints57137192lints
linty87126562linty
loti46431842loti
mini65634572min_i
mint66758072mint_
mints76834042mints
minty106323902minty
nidi56524412nidi
ninth8314582ninth
nisi45823252nisi
nit37065952nit_
nite45943592nite
nitid61817832nitid
nits45741652nits
nth66320592_nth
ontic74418572ontic
onto46127662onto
pint66963182pint_
pinta75727052pinta
pinto75625752pinto
pints75936222pints
roti46332932roti
sati45539332sati
senti56226702senti
snit46342472snit
ti28448302__ti
tint46758872tint_
tints56030922tints
titi47130632titi
unai44824782unai
unci65019462unci
unit45140072unit
untie54425492untie
until53517742until
unto45824282unto
yeti75823212yeti
ziti136022382ziti

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 Filter178691298720.470380193.6
2DLD Change Limit29872891.89015805.3
3Display Results89890.0165562.5
 (SQL Overall)178691892.37675206.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.