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

118 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
diplont1031169(None) 
diplonts1146471diplonts
diglot83014332diglo_t
diploe9810152diplo_e
diploes101111492diploes
diploic1247762diploic
diploid11310292diploid
diploma1295932diploma
diplomat1387432diplomat
diplontic1444522diplontic
displant11412222displant
haplont12412562haplont
billon83713833billon_
billons93013363billons
biont7727163bi__ont
biplane1139033biplane
ciphony1744973ciphony
coplot10518273coplo_t
dapsone1038463dapsone
daylong1233973daylong
depaint10314593depaint
deplane10311413deplane
deplore1039483deplore
deploy1237583deplo_y
deploys1336523deploys
depone93616553dep_one
deport94922393dep_ort
depot85727923dep_o_t
dialect101210263dialect
dialing94318173dialing
dialist8517763dialist
dialog837973dialo_g
dialogs938103dialogs
diamond1186113diamond
diaphone1447103diaphone
diaphony1744123diaphony
dicliny1337673dicliny
dicot85429093di_co_t
diglots9299503diglots
diluent8310263diluent
dimout9414243di_mout
dimpling14199023dimpling
dint56759053di___nt
diplex16408053dipl_ex
diploids1247843diploids
diploidy1544733diploidy
diplomas1385993diplomas
diplomata1484753diplomata
diplomate1476353diplomate
diplomats1485373diplomats
diplopia1344823diplopia
diplopic1545593diplopic
diplopod1453883diplopod
diploses111110323diploses
diplosis11128413diplosis
diplotene1244653diplotene
dipnet91317473dip_net
dipnoan1044653dipnoan
dipnoans1144103dipnoans
dipody1336363dip_ody
dipolar1056853dipolar
dipole91112853dip_ole
dipoles101013753dipoles
dipping134014833dipping
dipshit1347993dipshit
dipso85111553dipso__
dipsos95310053dipso_s
dipt77339323dip___t
dirling93316073dirling
discant103017253discant
discount11811313discount
disjoint1649233disjoint
dismount1188223dismount
displants1248073displants
displode1247643displode
disport101015953disport
disroot8413563disroot
dissent84018683dissent
distant83519953distant
distent84120853distent
distort81120333distort
diuron738573diuron_
diurons838823diurons
divalent1247783divalent
divot95723073di_vo_t
doblon938013doblon_
doblons1037043doblons
dopant9316133dop_ant
drylot1037403drylo_t
explant16310133explant
exploit1648623exploit
giglot84013133giglo_t
gipon84212413gip_on_
gipons9389603gip_ons
haplonts1345773haplonts
hipbone1445923hipbone
hipline12311423hipline
implant11311333implant
misplant12410753misplant
pieplant1268733pieplant
pilot77435063pi_lo_t
plant75437113__plant
plonk114613983__plonk
plot66141233__plo_t
replant93318533replant
replot83818593replo_t
ripost83615003rip_ost
silent64125843si_lent
siphon1138463siphon_
siphons1239353siphons
splent84720193_splent
splint85223283_splint
tiglon737923tiglon_
tiglons837343tiglons
violent102110813violent
violone1037153violone
wipeout1287873wipeout
ziplock2454413ziplock

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271186.62320236.6
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.07525256.7
 
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.