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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
inventor1129815(None) 
indentor9288511indentor
inventer112410841inventer
inventors12288251inventors
inventory15255631inventory
invertor11238971invertor
investor11247411investor
coinventor1562972coinventor
incenter102212092incenter
inceptor1246022inceptor
indenter92311442indenter
indentors10278312indentors
infector13478852infector
injector17236932injector
invent93316362invent__
invented122510662invented
inventers12269532inventers
invention1248332invention
invents102812052invent_s
inverter112411072inverter
invertors12239792invertors
investors12227722investors
accentor12106133accentor
ancestor1046853ancestor
assentor865293assentor
caveator1387233caveator
coinventors1652943coinventors
coinvestor1562573coinvestor
convector1648083convector
convenor13307613conven_or
convertor1448783convertor
envenom1244063enven_om
evertor1038723_evertor
incent83320723incent__
incented112412543incented
incenters112510303incenters
incents92414533incent_s
inceptors1345773inceptors
indent73021243indent__
indented101811733indented
indenters102710033indenters
indention1049513indention
indents83114663indent_s
indenture1045063indenture
indictor1147463indictor
inductor1146333inductor
infecter13229153infecter
infectors14218553infectors
inferior1156423inferior
infester11239433infester
inflator1158033inflator
inflector1465353inflector
inheritor1245633inheritor
injectors18216723injectors
inserter82312133inserter
insetter8218593insetter
inspector1344753inspector
intender93310443intender
intenser8199443intenser
intent63122773intent__
intention9412013intention
intently1149823intently
intents72115703intent_s
interior8513093interior
invected14258883invected
inventing13109973inventing
inventions1348313inventions
inventive1588043inventive
inventorial1453983inventorial
inventoried1552843inventoried
inventories1454703inventories
invert94120083invert__
inverted122312163inverted
inverters12239753inverters
invertin11910233invertin
inverts103211953invert_s
invest93014843invest__
invested12229693invested
invests10319683invest_s
inviter104112313inv_iter
mentor8414363__mentor
nestor63713423_n_estor
nonvector1445793nonvector
patentor1046373patentor
stentor739383_stentor
vector113212063__vector
vendor10359803__vendor
venter94218723__venter

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit146162886.51622431.2
3Display Results88880.0302933.3
 (SQL Overall)178691886.98225593.1
 
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.