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

108 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
portside113816(None) 
courtside1243352courtside
foreside12310302foreside
outside82414192_outside
poolside1145042poolside
potsie83916032po_tsi_e
preside10715612p_reside
proteide11239722proteide
boride9415903bor__ide
courtsides1343583courtsides
curbside1344673curbside
curtsied1134953curtsied
dockside16154743dockside
downside1345293downside
farside1138603far_side
fireside1247003fireside
footsie1047653footsi_e
foresides1339703foresides
ironside945853ironside
mortice11711493mort_ice
mortise9713533mort_ise
mortised1178743mortised
offside1453693_offside
onside7511803_o_nside
oreide7311673_or_eide
oroide7311703_or_oide
outride82615683_outride
outsider9269643_outsider
outsides92513233_outsides
outsize162411753_outsize
parasite10314843parasite
partied103516553part_ied
partite9317133part_ite
partridge1362863partridge
pentoside1255373pentoside
peptide122910683pept_ide
peroxide1848183peroxide
pintsize1955103pintsize
poetise9314043poet_ise
poetised1138523poetised
poetize18310773poet_ize
poetlike1436733poetlike
polypide1647013polypide
pontine92419053pont_ine
poolsides1254553poolsides
popsie103013053po_psi_e
porcine11312843por_cine
porkpie1544673porkpi_e
porose84818743poros__e
porosity1348593porosity
porpoise1248083porpoise
porridge1243763por_ridge
portable12313203portable
portage103013643port_age
portaged12228463portaged
portaled11239203portaled
portance12310123portance
portative1449373portative
ported94223243port_ed_
portend103411193portend_
portended1345643portended
portends11358963portends
portered112311543portered
porthole1349523porthole
portico11310143port_ico
portiere1038773portiere
porting103021783port_ing
portion9615493port_ion
portlier1038373portlier
ports75934593ports___
postcode1346323postcode
postdive1445763postdive
postfire1346273postfire
postie84123963post_i_e
postlude1144543postlude
postrider1246653postrider
potlike13910123po_tlike
potline91015233po_tline
potpie103412433po_tpi_e
potsies93019483po_tsies
poussie936623poussi_e
poutine93316823pout_ine
presided12410553p_resided
presider11410423p_resider
presides11414913p_resides
pride84724733p_r__ide
prossie91812953prossi_e
prostie91617743prosti_e
proteid103513673proteid_
proteides12238783proteides
proteids11259943proteids
protoxide1946823protoxide
protrade1148213protrade
protrude1144703protrude
provide1339853p_rovide
reside74224933__reside
roadside1044893roadside
shoreside1344733shoreside
sortie63621993sort_i_e
sortied83314103sort_ied
sporicide1484793sporicide
sportive1348333sport_ive
surfside1244853surfside
tootsie737133tootsi_e
topside1037733to_pside
torsade837593tor_sade
tortile7313193tort_ile
tortoise847093tortoise

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.440406115.9
2DLD Change Limit1461621086.67021913.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.15624970.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.