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

165 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
insister88878(None) 
insisted998671insisted
insisters997651insisters
assister836752assister
enlister847802enlister
inciter93113772inci_ter
indicter1148142indicter
inditer83514232indi_ter
infester11239432infester
inserter82312132inserter
insetter8218592insetter
insider849732insi_der
insist6314512insist__
insistent948252insistent
insists739082insist_s
insulter836882insulter
inviter104112312invi_ter
minister10410362min_ister
resister8311652resister
sinister838582sin_ister
sister64421582__sister
anointer837823anointer
assisted936233assisted
assisters936353assisters
assistor844823assistor
banister10199973banister
bannister1155373bannister
bister84922763__bister
blister94415313_blister
canister101710853canister
cannister1155723cannister
cloister1037093cloister
consisted1238503consisted
demister11310223demister
desisted1039783desisted
disaster949943disaster
disinter9310673disinter
enlisted978193enlisted
enlistee868323enlistee
enlisters937113enlisters
filister1137403filister
fillister1244423fillister
finisher1436303fin_isher
ganister9178993ganister
gannister1054173gannister
glister84013343_glister
grister83915413_grister
heister103613623_heister
hoister103714203_hoister
igniter8147673igni_ter
imbitter12265283imbitter
imposter12288163imposter
incenter102212093incenter
incise83515333incis_e_
incised102911583incis_ed
incises93414893incis_es
incisor955323incis_or
incisure1044563incisure
incite83618733inci_te_
incited103314623inci_ted
inciters103210673inci_ters
incites93218483inci_tes
indenter92311443indenter
indicted1249203indicted
indictee1149623indictee
indicters1236733indicters
indictor1147463indictor
indite73520323indi_te_
indited93515023indi_ted
inditers93311053indi_ters
indites83618983indi_tes
infecter13229153infecter
infested12249643infested
infesters12237713infesters
infighter1644273infighter
inflater1149893inflater
inflicter1444453inflicter
infuser10298323infus_er
ingested10259003ingested
inhibiter1444403inhibiter
inkier104013783inki__er
inlier63615363inli__er
inosite7314063inosi_te_
inosites8312793inosi_tes
inputter1034203inputter
insaner7310443ins_aner
inserted92413053inserted
inserters92210283inserters
insetted9249023insetted
insetters9187133insetters
inside7613453insi_de_
insiders947763insi_ders
insides8512653insi_des
insigne837673insigne_
insincere1143683insincere
insistence1246013insistence
insistency1553973insistency
insisting1038823insisting
insnarer865303insnarer
inspirer1045183inspirer
instanter946243instanter
instar6310013in__star
instate71616483instate_
instated91613343instated
instates81615833instates
instep838193in__step
instiller944953instiller
instituter1044513instituter
insulted937193insulted
insulters945883insulters
insurer73312803ins_urer
inter55028493in___ter
intimater111110583intimater
intwisted1344333intwisted
inventer112410843inventer
inverter112411073inverter
invested12229693invested
investor11247413investor
invite93715033invi_te_
invited113612463invi_ted
invitee103713543invi_tee
inviters11359643invi_ters
invites103915813invi_tes
issuer646623i_s_suer
keister113011573_keister
klister113410643_klister
knitter11348133kn_itter
lamister1037653lamister
leister73212753_leister
lister64527253__lister
magister1136283magister
meister93114163_meister
ministers1139623min_isters
minster93914323min__ster
misinter1038833misinter
mister84728563__mister
moister94015373_moister
nester64124183_n_ester
niter55028973_n_i_ter
noisier759453_noisier
persister1146833persister
pinaster1037113pin_aster
pinsetter1145013pinsetter
plaister1068013plaister
register939553register
resisted9312693resisted
resisters9310453resisters
resistor847673resistor
roister73516203_roister
sifter94516233__sifter
sinter63625923__sinter
sisters73721593__sisters
sitter63323383__sitter
snifter10349623sn_ifter
subsister1145983subsister
twister10308953_twister
unbitter1046173unbitter
uniter64619143un_i_ter
unlisted9311153unlisted
unmiter9310393unmi_ter
unsicker1435303unsicker
unsifted12128773unsifted
unwiser1037123unwis_er
visiter1038863visi_ter
waister103812383_waister

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.406440125.6
2DLD Change Limit1461621657.04620744.0
3Display Results1651650.0802062.5
 (SQL Overall)1786911657.53223724.2
 
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.