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

103 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
purport115939(None) 
purports1265781purports
airport9511382airport
carport11316032carport
outport9714122outport
purported1443452purported
purpose1137382purpose
purpura1144792purpura
purpure1195992purpure
support11310522support
airports1046463airports
airpost939243airpost
aport75432173__aport
aurora6411763aur_ora
burbot10815653burbo_t
burgout1049773burgout
burnout9310453burnout
carports1238943carports
comport133616843comport
corpora1139353corpora
cursor84110293cursor_
cursors93910023cursors
cursory12406393cursory
deport94922393_deport
disport101015953disport
export15412183_export
furor8312393fur_or_
furore9410013fur_ore
furors9310953fur_ors
gosport101010283gosport
import102713753_import
jetport1646643jetport
juror1239563jur_or_
jurors1338283jur_ors
mugwort1346753mugwort
outports1048273outports
outpost9612443outpost
parlor8312673parlor_
parlors9312913parlors
parrot8320663parro_t
passport1247593passport
perform1439273perform
perpent112318803perpent
pervert12315583pervert
piefort1249533piefort
port66059633___port
pourpoint1345213pourpoint
presort95219533presort
prior74316173p_rior_
priors83914483p_riors
priory114110263p_riory
prost75434103p_r_ost
prutot8311823pruto_t
puerpera1242853puerpera
pullout9310593pullout
pulper103513273pulper_
pulpers114612283pulpers
pulpit10310933pulp_it
pulpous1177013pulpous
pumper124415553pumper_
pumpers133113673pumpers
puppet93514593pu_ppet
purer75127903pur_er_
purest84021933pur_est
purger94717233purger_
purgers104714003purgers
purist85525053pur_ist
purloin9107493purloin
purple102712673purp_le
purpled12299753purpled
purpler11289263purpler
purples112712823purples
purplest12249123purplest
purply13369043purp_ly
purporting1543793purporting
purposed1335253purposed
purposes1237823purposes
purpuras12105073purpuras
purpures1276143purpures
purpuric1463763purpuric
purpurin1254583purpurin
purr64925813pur__r_
purrs75320433pur__rs
purser85020473purser_
pursers93916093pursers
pursuit948273pursuit
putout8315113pu_tout
rapport11311223rapport
report85326013_report
seaport9315593seaport
sport75935983__sport
subpart11311123subpart
superport13410703superport
supports1246513supports
surcoat9412923surcoat
surtout7411673surtout
torpor839193torpor_
torpors939373torpors
turbot8914263turbo_t
turgor736863turgor_
turgors836823turgors
turnout7410283turnout
uproot8314123upr_oot

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.1531167915.0
2DLD Change Limit1340271037.09618887.7
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.29524495.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.