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

103 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
invertins1291102(None) 
invertin11910231invertin_
inverting131013221inverting
inertias8410382in_ertias
inserting10914242inserting
insertions10410342insertions
interties9320332interties
inventing13109972inventing
inventions1348312inventions
inverities13410622inverities
inversing1389622inversing
inversions1347002inversions
inverters12239752inverters
invertors12239792invertors
inverts103211952invert__s
investing13119392investing
adverting1437223adverting
averting122512733_averting
cinerins10414103cin_er_ins
converting16313133converting
diverting142410333diverting
entertains1047623entertains
everting122213133_everting
fingertips1692773fingertips
incenting12912063incenting
incepting1489293incepting
inceptions1448533inceptions
incretions1248653incretions
indenting11911263indenting
indentions1149063indentions
inertia7410203in_erti_a
inertiae8411473in_ertiae
inertial8411723in_ertial
inerts64517023in_ert__s
infecting15109673infecting
infections15510233infections
inferring1338613inferring
infertile1248673infertile
infesting13109513infesting
ingesting11129623ingesting
ingestions1197593ingestions
ingrains948983in_grains
inhering12913713inher_ing
inheriting1448853inheriting
inherits11310103inher_its
injecting1997693injecting
injections1948663injections
inletting1087873inletting
innerving1346503innerving
inserters92210283inserters
insertion9410593insertion
inserts74013993insert__s
insetting1079283insetting
intentions10411403intentions
interims101013073inter_ims
interjoins1747953interjoins
interline91218013interline
interlines101116453interlines
interlink131310663interlink
interlinks14137503interlinks
intermits111212203intermits
interning10315253interning
interns73116773inter__ns
interring10315423interring
intertie8317613interti_e
intertill9410423intertill
intertills1048223intertills
intertwine1347613intertwine
intertwines1446643intertwines
intestine9411853intestine
intestines10410253intestines
intorting10311413intorting
invective1798043invective
invectives1885903invectives
inventers12269533inventers
invention1248333invention
inventive1588043inventive
inventors12288253inventors
invents102812053invent__s
inverity1447963inver_ity
inverness1247133inverness
inverses112410983inver_ses
inversion1247213inversion
inversive1557193inversive
invert94120083invert___
invertase1245833invertase
invertases1345783invertases
inverted122312163invert_ed
inverter112411073invert_er
invertible1547503invertible
invertor11238973invert_or
investors12227723investors
invests10319683invest__s
inviting1239733inv_iting
kinetins12228153kin_e_tins
obverting1536303obverting
overtips1338353_overtips
poverties1439513poverties
reverting132315133reverting
underpins1239733underpins
undertint10414863undertint
undertints1148283undertints
verdins112812333__verdins

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411036.40623203.4
3Display Results1031030.0631634.9
 (SQL Overall)1786911036.90525878.5
 
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.