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

189 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
dislikes13281084(None) 
dislike122913451dislike_
disliked14288551disliked
disliker13358641disliker
dislikers14286421dislikers
mislikes143311831mislikes
dillies84122162dilli_es
disclike15208652disclike_
dishlike16287892dishlike_
disklike12206742disklike_
dislimns1144812dislimns
disyokes1656502disyokes
mislies92922282misli_es
mislike132914832mislike_
misliked15319512misliked
misliker14319572misliker
mislikers15317062mislikers
mislives132912152mislives
airlike11310333airlike_
airlines8312793airlines
aisles64721143aisl__es
alsikes1137263als_ikes
asslike1137373asslike_
beslimes1246953beslimes
bialies93618413biali_es
biblike1536893biblike_
billies93923503billi_es
cilices113814023ci_lices
cissies94116153cissi_es
dailies84219263daili_es
daishikis1751643daishikis
daisies84217093dais_i_es
dallies84023193dalli_es
dashikis1643673dashikis
dassies84418663dassi_es
declines113315803declines
delimes10314193d_elimes
dellies83622213delli_es
desires81316133des_ires
despises1139433despises
despites11410313despites
destines93619663destines
dialings10329823dialings
dialists9411413dialists
dialyses1236133dialyses
dialyzes2144503dialyzes
diamides1238823diamides
diamines11311643diamines
diaries83321953diari_es
diazines1838713diazines
dickies143416343dicki_es
diclinies1247833diclinies
diddlies1137593diddli_es
didies84621833di_di_es
dieselizes2043943dieselizes
dikdiks1242563dikdik_s
dikes105831333d___ikes
dilates83220663di_lates
dildoes9229243di_ldoes
dilutes82911973di_lutes
dingies93618243dingi_es
dinkies123716033dinki_es
diorites9313523diorites
dioxides1756203dioxides
diploes101111493dipl_oes
diploses111110323diploses
dirties83119383dirti_es
disables11410903disables
discases112014503discases
disciples1446403disciples
discloses1249473discloses
discuses113112863discuses
diseases92415813diseases
diseuses93112763diseuses
disguises1146873disguises
dishes104622653dis__hes
dishier113613403dishi_er
dishiest12313683dishi_est
disked125015763dis__ked
disks105417473dis__k_s
disliking1537313disliking
dislimn1056103disli_mn
dislimned1344623dislimned
dislodges1245163dislodges
dismes95617673dis__mes
dismiss1038153dismi_ss
dismisses1245503dismisses
disobliges1453073disobliges
displaces1448593displaces
displodes1347863displodes
displumes1444983displumes
disposes11313823disposes
disprizes2148113disprizes
disputes1139653disputes
disrates91118153disrates
disrobes1139743disrobes
dissaves1239413dissaves
disseises1039333disseises
disseizes1946823disseizes
disses75225963dis__ses
distaves12311403distaves
distichs1447633distichs
distills9319043distills
distils83015803disti_ls
distomes11314163distomes
disulfides15143743disulfides
disunites1088673disunites
disuses84015413dis_uses
disyoke1546233disyoke_
disyoked1745463disyoked
ditties83116983ditti_es
divides123211453di_vides
divines113514723di_vines
divvies1457663divvi_es
dizzies16279753dizzi_es
doglike13207453doglike_
doilies84017363doili_es
dollies83620983dolli_es
doolies83920713dooli_es
doylies114512573doyli_es
dualizes1838823dualizes
dustlike1335363dustlike_
fillies103420253filli_es
finlike14279063finlike_
fishlike18225873fishlike_
fishlines15246843fishlines
gillies84120963gilli_es
girlies83013703girli_es
hiplike1637603hiplike_
hiplines13310593hiplines
hissies103915823hissi_es
idolises938763idolises
idolizes1837553idolizes
illites72415013_illites
iolites73819483_iolites
isles54220563_isl__es
isolines8312303_isolines
jiglike19105333jiglike_
kidlike1137063kidlike_
killies113318113killi_es
kishkes1334773kis_hkes
kylikes1333583_kylikes
likes96231903___likes
lilies63021413li_li_es
liplike1337283liplike_
lisles63416283lisl__es
midlines112613333midlines
midlives14287463midlives
millimes122411373millimes
millines102718063millines
miscites12313783miscites
misfiles133110983misfiles
misfires132210583misfires
misgives14329293misgives
mislie83219153misli_e_
mislive122812693mislive_
mislived14328783mislived
mismakes16129883mismakes
missies93423983missi_es
missiles103015083missiles
missises103513693missises
missives133212843missives
mistakes141213413mistakes
mistimes12612613mistimes
misyokes1735513misyokes
muspikes1635243muspikes
niblike1336703niblike_
piglike14157313piglike_
pismires1235883pismires
pisolites1149383pisolites
puslike1347563puslike_
riblike1337333riblike_
sikes96236083__s_ikes
silkies113715693si_lkies
sillies73425083silli_es
sissies73716603sissi_es
slakes104021883__slakes
slices84022853__slices
slides73922183__slides
slimes84722043__slimes
slipes84921413__slipes
spikes124520713__spikes
susliks1136443suslik_s
tillites8312833tillites
tinlike11248803tinlike_
viselike1536923viselike_
wiglike15125853wiglike_
willies103920153willi_es
wisplike1734713wisplike_

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.423422437.4
2DLD Change Limit1461621897.34319904.9
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.84622774.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.