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 “insertions” 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
insertions1041034(None) 
insertion9410591insertion_
assertions1046582assertions
desertions1139882desertions
exsertions1746742exsertions
inceptions1448532inceptions
incretions1248652incretions
indentions1149062indentions
infections15510232infections
ingestions1197592ingestions
injections1948662injections
inserting10914242inserti_ng
insertional1147462insertional
inspections1546422inspections
intentions10411402intentions
inventions1348312inventions
inversions1347002inversions
invertins12911022inverti_ns
reinsertions1245272reinsertions
assertion946723assertion_
bisections14136733bisections
caseations1258303caseations
desertion10410203desertion_
dissections14198263dissections
dissentions12168043dissentions
exertions1639763_exertions
exsections1947633exsections
exsertion1646853exsertion_
ideations1039903i_deations
immersions1444003immersions
inactions1139323in_actions
inanitions1046383inanitions
incautions1245973incautions
inception1348693inception_
incretion1149053incretion_
incursions1244833incursions
indention1049513indention_
indexations1946023indexations
indictions1339313indictions
inductions1348803inductions
indurations1249583indurations
inertias8410383in_erti_as
infarctions1645023infarctions
infection14410473infection_
infectious1545603infectious
inferiors1266543infer_iors
inflations13310323inflations
inflections1646993inflections
ingestion10137483ingestion_
inheritors1345633inheritors
inhesions12116123inhe_sions
injection1838653injection_
innervations1546923innervations
inscriptions1654503inscriptions
insentient1049423insentient
inserters92210283insert_ers
inserts74013993insert___s
insetting1079283insetti_ng
insolations1149183insolations
inspection1446663inspection_
inspirations1447303inspirations
instructions14137813instructions
insulations11310233insulations
integrations13129473integrations
intensions1048403intensions
intention9412013intention_
interactions14410463interactions
interiors9513563inter_iors
interjoins1747953interjoins
interties9320333interti_es
intertills1048223intertills
intuitions1047293intuitions
inunctions1246753inunctions
invention1248333invention_
inversion1247213inversion_
invertin11910233inverti_n_
inverting131013223inverti_ng
invertors12239793invert_ors
iterations10413823i_terations
lineations1039543lin_eations
midsections1644403midsections
reinsertion1145443reinsertion_
resections121513033resections
sections102714703__sections
unserious946803unser_ious

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.436409841.7
2DLD Change Limit140603856.09323076.2
3Display Results85850.0501700.0
 (SQL Overall)178691856.57927160.8
 
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.