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

85 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
inventions134831(None) 
indentions1149061indentions
intentions10411401intentions
invention1248331invention_
conventions16410532conventions
inceptions1448532inceptions
indention1049512indention_
infections15510232infections
ingestions1197592ingestions
injections1948662injections
insertions10410342insertions
intensions1048402intensions
intention9412012intention_
inventing13109972inventi_ng
inventors12288252invent_ors
inversions1347002inversions
invertins12911022inverti_ns
reinventions1554212reinventions
advections1645553advections
attentions1045983attentions
contentions13412093contentions
convections18411493convections
convention15410563convention_
detentions11148803detentions
dissentions12168043dissentions
distentions12178843distentions
evections142510693_evections
ideations1039903i_deations
inactions1139323in_actions
inanitions1046383inanitions
inattentions1252603inattentions
incautions1245973incautions
incenting12912063incenti_ng
incentives1578043incentives
inception1348693inception_
incretions1248653incretions
indentations1347883indentations
indenting11911263indenti_ng
indentors10278313indent_ors
indexations1946023indexations
indictions1339313indictions
inductions1348803inductions
infection14410473infection_
infectious1545603infectious
inflations13310323inflations
inflections1646993inflections
ingenious1046013ingen_ious
ingestion10137483ingestion_
inhesions12116123inhe_sions
injection1838653injection_
injunctions2044883injunctions
insentient1049423insentient
insertion9410593insertion_
inspections1546423inspections
intension948493intension_
intentional11128843intentional
interventions1657513interventions
intinctions1347003intinctions
intonations1149523intonations
intuitions1047293intuitions
inunctions1246753inunctions
invasions12115413inv_asions
invectives1885903invectives
inventers12269533invent_ers
inventive1588043inventi_ve
inventor11298153invent_o_r
inventory15255633invent_ory
inventress1343623inventress
invents102812053invent___s
inversion1247213inversion_
invertin11910233inverti_n_
inverting131013223inverti_ng
invertors12239793invert_ors
investing13119393investi_ng
investors12227723invest_ors
invitations1449053invitations
invocations1647063invocations
involutions1445903involutions
lineations1039543lin_eations
mentions10312893__mentions
preventions1648533preventions
reinvention1454513reinvention_
retentions101611113retentions
subventions1674843subventions
venations12311723__venations

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 Filter1786911406030.390458182.1
2DLD Change Limit140603855.78024325.8
3Display Results85850.0302833.3
 (SQL Overall)178691856.20028821.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.