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 “disinters” 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
disinters103971(None) 
disinter9310671disinter_
misinters1138181misinters
diesinkers1552782diesinkers
disasters1039152disasters
disinterest1255612disinterest
disputers1236612disputers
dissenters1197722dissenters
disuniters11104732disuniters
diviners12308352divin_ers
misenters1139532misenters
misinfers1445482misinfers
misinter1038832misinter_
sinters74024082__sinters
visiters1137412visi_ters
absenters1156173absenters
anointers937003anointers
assenters966993assenters
assisters936353assisters
bisters93922613bis__ters
cointers103616413_cointers
daunters9329853d_aunters
decanters12229223decanters
decenters122410373decenters
definers124211193defin_ers
demisters1249203demisters
depicters1435823depicters
deringers1137183deringers
desalters1037673desalters
descanters1345013descanters
deserters10129983deserters
designers1136003designers
desilvers13306083desilvers
desirers939263desi_rers
diameters1247603diameters
diasters92913183di_asters
diesinker1462513diesinker_
diesters92513603di_esters
dieters83216433d__ieters
digesters11257883digesters
dilaters92513063di_laters
diluters9288113di_luters
dimeters11411093di_meters
diners75525953d__in_ers
dingers94321383d__ingers
dinners83915443d__inners
diopters1137693di_opters
disablers1255803disablers
disarmers1246943disarmers
disaster949943disaster_
discounters1445753discounters
discovers1538153discovers
dishwaters1744023dishwaters
disinfect1545043disinfect
disinfects1653653disinfects
disinfest1346903disinfest
disinfests1443883disinfests
disinform1544123disinform
disinforms1653253disinforms
disinherit1455503disinherit
disinherits1554013disinherits
disinterests1353133disinterests
disinterred1353933disinterred
disinvest1346803disinvest
disinvests1443763disinvests
disinvites1445153disinvite_s
dislikers14286423dislikers
disorders1146963disorders
dispensers13146743dispensers
disposers1238373disposers
disputer1137973disputer_
disputes1139653dispute_s
disrates91118153disrate_s
disrobers1246383disrobers
disrupters1343933disrupters
dissenter1059133dissenter_
dissevers1386863dissevers
dissipaters1453473dissipaters
distenders12166733distenders
distillers1145133distillers
distincter1345303distincter_
distorters1147163distorters
disuniter1086203disuniter_
disunites1088673disunite_s
ditsiness1048143ditsin_ess
diverters13227873diverters
dividers13257213divi_ders
diviner11369883divin_er_
divines113514723divin_e_s
domineers1244673domineers
dosimeters1345113dosimeters
drainers92811253drain_ers
drifters12417913d_rifters
drinkers13277823d_rinkers
dusters84918363dus__ters
dysentery1643043dysentery
fainters11349693_fainters
filisters1237003filisters
hinters103719583__hinters
igniters9126233_igniters
insisters997653insisters
inters64328053___inters
jointers15289323_jointers
limiters10249333limi_ters
linters73822633__linters
listers74026533lis__ters
midwinters1642483midwinters
ministers1139623ministers
minters93822473__minters
misalters1136913misalters
misenter10310833misenter_
mishanters1544983mishanters
misinfer1345323misinfer_
misters93927513mis__ters
painters103013023_painters
pointers103013723_pointers
printers103214903_printers
reinters82614773_reinters
resisters9310453resisters
sifters103714793__sifters
singers83824703__singers
sinkers113618543__sinkers
sinners74019023__sinners
sinter63625923__sinter_
sisters73721593__sisters
sitters74221553__sitters
splinters11277923splinters
sprinters11329363sprinters
squinters1835523squinters
stinters83312753_stinters
tinters74221113__tinters
visiter1038863visi_ter_
visitors1146433visi_tors
winters103720483__winters

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411346.03324638.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.51627423.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.