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

94 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
investor11247411investor
investors12227721investors
invests10319681invest_s
incests92711382incest_s
infests10279792infest_s
ingests83210982ingest_s
inventor11298152inventor
inventors12288252inventors
invents102812052invent_s
invertor11238972invertor
invertors12239792invertors
inverts103211952invert_s
invest93014842invest__
invested12229692invested
ancestor1046853ancestor
ancestors1147233ancestors
asbestos1044353asbestos
cavettos1344973cavettos
cestos84718093__cestos
coinvestor1562573coinvestor
coinvestors1672873coinvestors
devests114410473devest_s
divests114510933divest_s
impastos12244833impastos
incents92414533incent_s
inceptor1246033inceptor
inceptors1345783inceptors
incepts11238293incept_s
incest82918743incest__
incestuous1252573incestuous
indentor9288513indentor
indentors10278313indentors
indents83114663indent_s
inerts64517023in_ert_s
infector13478853infector
infectors14218553infectors
infects12279713infect_s
infernos1145903infernos
infest93315433infest__
infested12249643infested
infester11239433infester
infesters12237713infesters
ingest73119003ingest__
ingesta8357863ingest_a
ingested10259003ingested
ingestion10137483ingestion
ingestions1197593ingestions
inhesion11116373inhesion
inhesions12116123inhesions
injector17236933injector
injectors18216723injectors
injects16257453inject_s
inlets63915573inle_t_s
inmeshes1345613inmeshes
inquests1744943inquest_s
insects93710843insect_s
inserts74013993insert_s
insets64016133inse_t_s
insists739083insist_s
intents72115703intent_s
invasion11115473invasion
invasions12115413invasions
invected14258883invected
inveighs1542743inveighs
invent93316363invent__
invented122510663invented
inventer112410843inventer
inventers12269533inventers
invention1248333invention
inventions1348313inventions
inventory15255633inventory
inverses112410983inverses
inversion1247213inversion
inversions1347003inversions
invert94120083invert__
invertase1245833invertase
inverted122312163inverted
inverter112411073inverter
inverters12239753inverters
invertin11910233invertin
invertins12911023invertins
investing13119393investing
invites103915813inv_ites
nestor63713423_n_estor
nestors73614973_n_estors
nests55728003_n_est_s
pestos84719083__pestos
prestos93716083_prestos
reinvests1244223reinvest_s
revests104413733revest_s
unrests7229463unrest_s
unvested122210223unvested
vestas95916683__vestas
vests85325983__vest_s

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.420425454.8
2DLD Change Limit146162947.12620511.1
3Display Results94940.0332848.5
 (SQL Overall)178691947.57923577.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.