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

134 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
insisting103882(None) 
assisting1046182assisting
consisting1349522consisting
desisting112810382desisting
enlisting1038342enlisting
incising11411092incis_ing
inciting11312532inci_ting
indicting1339612indicting
inditing10312112indi_ting
infesting13109512infesting
ingesting11129622ingesting
inserting10914232inserting
insetting1079282insetting
insistent948252insistent
instating10812212instating
insulting1038052insulting
intwisting1445062intwisting
investing13119392investing
inviting1239732invi_ting
resisting103215312resisting
agisting1038243_agisting
anointing1038623anointing
bemisting1438073bemisting
delisting112710503delisting
encysting1544613encysting
enditing10311073endi_ting
enisling949633en_isling
ensiling9410723ensi_ling
entwisting1443853entwisting
existing1639073_existing
finishing1645843fin_ishing
fisting113818123__fisting
foisting122910503_foisting
heisting123411043_heisting
histing113720373__histing
hoisting123610903_hoisting
igniting1037363igni_ting
impasting1436323impasting
imposting1436813imposting
incanting1289903incanting
incasing11610603incas_ing
incenting12912063incenting
incepting1489293incepting
incrusting13126473incrusting
incusing1159953incus_ing
indenting11911263indenting
indicating1449693indicating
indistinct1364823indistinct
inducting1338373inducting
infecting15109673infecting
infighting1844413infighting
infirming1545163infirming
infixing1936103infi_xing
inflating13310443inflating
inflicting1645723inflicting
infusing1237893infus_ing
ingoting1039863in_goting
inhibiting1645113inhibiting
initiating1149623initiating
injecting1997693injecting
inletting1087873inletting
inmeshing1595333inmeshing
inputting1235823inputting
inquieting2044523inquieting
inrushing1365503inrushing
insinuating1244533insinuating
insist6314513insist___
insisted998673insist_ed
insistence1246003insistence
insistency1553973insistency
insister888783insist_er
insisters997653insisters
insists739083insist__s
insnaring1046313insnaring
insolating1149153insolating
insouling1036823insouling
inspecting1546223inspecting
inspiring1246183inspiring
inspiriting1443643inspiriting
inspissating1551503inspissating
instigating1347153instigating
instilling1145803instilling
instituting1244803instituting
insulating1139263insulating
insuring9311153ins_uring
inswathing1742973inswathing
intestine9411853intestine
intimating13410823intimating
intitling1037213intitling
intorting10311413intorting
intrusting11128173intrusting
intuiting1089613intuiting
inventing13109973inventing
inverting131013223inverting
inwinding1445173inwinding
iodising1037563iodis_ing
ionising9310223ionis_ing
irising83614423i_ris_ing
issuing836053i_s_suing
joisting16328503_joisting
knitting13257023kn_itting
listing84020593__listing
minishing1547073min_ishing
misting103623383__misting
nesting84320443_n_esting
noising83615173_nois_ing
persisting1346653persisting
positing11312303posi_ting
relisting102414353relisting
resifting133512093resifting
resiting93521123resi_ting
resitting103414873resitting
sifting113014593__sifting
silting83320483__silting
siting74126623__si_ting
sitting83519633__sitting
subsisting1345533subsisting
twisting12427813_twisting
unfitting1336423unfitting
uniting8315823un_i_ting
unresting10311133unresting
unseating10713203unseating
unsetting1088993unsetting
unshifting1743863unshifting
unsighting1584443unsighting
unstating10711213unstating
unstinting1147303unstinting
untwisting1443943untwisting
unwishing1635593unwishing
unwitting1335583unwitting
visiting1238393visi_ting
waisting123615213_waisting
whisting15329543_whisting
wisting113519743__wisting

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.420425454.8
2DLD Change Limit1486411347.00021234.4
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.48323879.6
 
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.