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

198 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
inserting1091424(None) 
insetting1079281insetting
inverting131013221inverting
asserting1038662asserting
deserting11713142deserting
disserting121310852disserting
enserfing1345892enserfing
exserting1736662exserting
incenting12912062incenting
incepting1489292incepting
indenting11911262indenting
infecting15109672infecting
inferring1338612inferring
infesting13109512infesting
ingesting11129622ingesting
inhering12913712inher_ing
inheriting1448852inheriting
injecting1997692injecting
inletting1087872inletting
innerving1346502innerving
insertion9410592insertion
insertions10410342insertions
insisting1038822insisting
inspecting1546222inspecting
instating10812212instating
insulting1038052insulting
insuring9311152insur_ing
interning10315252interning
interring10315422interring
intorting10311412intorting
inventing13109972inventing
inversing1389622inversing
invertin11910232invertin_
invertins12911022invertins
investing13119392investing
reinserting1256902reinserting
unseating10713202unseating
unsetting1088992unsetting
absenting1236993absenting
adverting1437223adverting
alerting91312383_alerting
angering102113803anger_ing
anserine8313093anser_ine
answering1345803answer_ing
assenting1038163assenting
assorting1037303assorting
averting122512733_averting
besetting12268423besetting
bisecting1436973bisecting
caseating12311743caseating
cindering13311223cinder_ing
concerting15313893concerting
consenting13313213consenting
conserving1639763conserving
consorting13410743consorting
converting16313133converting
deserving1497903deserving
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
diverting142410333diverting
ensuring9310173ensur_ing
entering91920053enter_ing
everting122213133_everting
exerting162211153_exerting
experting1938053experting
exsecting1935933exsecting
fingering1439193finger_ing
fingerling1544833fingerling
gingering1238873ginger_ing
hindering14310273hinder_ing
ideating10311703i_deating
immerging1544103immerging
immersing1445123immersing
imparting1437243imparting
importing1438193importing
inarming1138343in_arming
inbeing1038333inbe__ing
incanting1289903incanting
incensing1297663incensing
inciting11312533in_citing
incurring1236873incurring
incurving1545373incurving
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
indorsing1137143indorsing
inducting1338373inducting
indurating1249243indurating
inearthing1443543inearthing
inertia7410203in_erti_a
inertiae8411473in_ertiae
inertial8411723in_ertial
inertias8410383in_ertias
infertile1248673infertile
infirming1545163infirming
inflating13310443inflating
inflecting1646313inflecting
informing1537023informing
ingoting1039863in_goting
injuring1637473injur_ing
inmeshing1595333inmeshing
innervating1546363innervating
inputting1235823inputting
inscribing1543853inscribing
insectan1045393insectan_
insectile1147113insectile
insentient1049423insentient
insert64325253insert___
inserted92413053insert_ed
inserter82312133insert_er
inserters92210283inserters
insertional1147463insertional
inserts74013993insert__s
insheathing18102693insheathing
inshrine1147493inshr_ine
inshrining14104583inshrining
insnaring1046313insnaring
insolating1149153insolating
insouling1036823insouling
insphering1644193inspher_ing
inspiring1246183inspiring
inspiriting1443643inspiriting
instarring1144063instarring
instructing1446293instructing
insulating1139263insulating
inswathing1742973inswathing
integrating1349493integrating
intending1139983intending
interacting14411713interacting
interesting12411123interesting
intergang11117893intergang
interline91218013interline
interlink131310663interlink
intertie8317613interti_e
interties9320333interties
intertill9410423intertill
intertwine1347613intertwine
intestine9411853intestine
intreating11614013intreating
intuiting1089613intuiting
inuring81213013in_ur_ing
inurning937553in_urning
inviting1239733in_viting
inweaving1644773inweaving
iterating10314253i_terating
lingering11310513linger_ing
miseating121215433miseating
misseating131310943misseating
missetting13107903missetting
missorting1347123missorting
nerving112910833_n_erving
nesting84320443_n_esting
netting84018763_n_etting
nidering10510483nider_ing
observing1544393observing
obverting1536303obverting
preinserting1544173preinserting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
reserving131110643reserving
resetting102816293resetting
resorting10614613resorting
reverting132315133reverting
seating84130683__seating
serging93416673__serging
sering74731813__ser_ing
serving113014983__serving
setting83621393__setting
sintering101014803sinter_ing
sneering93414503sneer_ing
snorting92613373sn_orting
sorting83221813__sorting
tinkering1437703tinker_ing
tinseling1036643tinse_ling
tinselling1145523tinselling
unbelting1237663unbelting
underling111514613underling
undertint10414863undertint
underwing141410883underwing
unerring9311273un_erring
unnerving1336633unnerving
unresting10311133unresting
unsealing10711043unsealing
unseaming1278113unseaming
unseeing988293unse_eing
unselling10810333unselling
unsettling1144433unsettling
unsewing1287433unse_wing
unsexing1686853unse_xing
unstating10711213unstating
unstring9312093unstr_ing
unswerving1743043unswerving
unweeting1336473unweeting
upsetting1275563upsetting
wintering13412363winter_ing

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411986.89021573.4
3Display Results1981980.0932129.0
 (SQL Overall)1786911987.38924183.4
 
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.