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

143 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
portray123748(None) 
portrays1345291portrays
mortary12369042mortary
orfray1234392_orfray
partway1535922partway
poetry1139382poetr_y
portal84218462port_al
portly114713402port_ly
portrait10510322portrait
portrayal1442472portrayal
portrayed1564102portrayed
portrayer1464002portrayer
aorta55922573aort_a_
aortae65115473aort_ae
aortal65217513aort_al
aortas65417783aort_as
array86317143_ar_ray
ashtray13805553ashtray
astray95615543_astray
betray111511443_betray
borty105522833bort__y
contra83314703contra_
contrary1347493contrary
contras93015623contras
corral83616253cor_ral
dorty96220813dort__y
estray95713333_estray
footway1635253footway
foray115023973fo__ray
forebay1538133forebay
foreran10311793foreran
fortify1636523fortify
forty114824273fort__y
hooray123011373ho_oray
horary12310383horar_y
hurray12459913hur_ray
lorry86315673lor_r_y
moray105423793mo__ray
mortal84616853mort_al
mortar83812043mort_ar
mortars93411523mortars
mortify1536223mortify
mortuary1373923mortuary
notary92310713no_tary
orfrays1343533_orfrays
orra46120723_or_ra_
outlay92711793_outlay
outpray12268083_outpray
outran63218893_outran
outsay92611873_outsay
paltry114910403paltr_y
pantry115014103pantr_y
parkway1934553parkway
parlay113713993par_lay
parral85517533par_ral
parry105323753par_r_y
partan83820563part_an
partial92616263partial
partly116315473part_ly
party106630613part__y
parura8310583parura_
paruras9310533paruras
pastry114913033pastr_y
peltry11288653peltr_y
peroral9314793peroral
perry105222713per_r_y
pertly115312553pert_ly
peytral1287503peytral
phratral1344373phratral
phratry1543743phratr_y
poitrel936193poitrel
poorly1137893po_orly
popery134511703poper_y
porgy116916123po__rgy
porky145019333po__rky
porny106020193po__rny
port66059633port___
portably1539313portably
portage103013643portage
portals94015563portals
portapak1642343portapak
ported94223243port_ed
portend103411193portend
portent93619643portent
porter84224413port_er
porterage1245763porterage
portered112311543portered
porters93722703porters
portico11310143portico
porting103021783porting
portion9615493portion
portraits1146803portraits
portrayals1552003portrayals
portrayers1553603portrayers
portraying1645163portraying
portress1038323portress
ports75934593port__s
postal84317533post_al
postbag1245223postbag
postboy1476673postboy
postgrad1245493postgrad
postman112410043postman
postoral10311723postoral
postrace12310543postrace
posttax1645533posttax
postural1049203postural
postwar1236903postwar
potboy1397813po_tboy
potman102813573po_tman
potsy105815613po_t_sy
pottery123011073pottery
potty105621003po_t_ty
poultry1235383poultr_y
pouty107018813pout__y
poverty1536433poverty
pray96331533p___ray
prepay13310313p_repay
program12311693program
protea82214763protea_
protean92412193protean
proteas92015123proteas
protract12510603protract
protrade1148213protrade
purty105019403purt__y
rostra6310933rostra_
rostral7311333rostral
rotary92411303ro_tary
sororal7310653sororal
sorry84618253sor_r_y
sorta57125413sort_a_
sporran936743spor_ran
sportily1337733sportily
sporty115112493sport__y
stray88525573__stray
torta55925353tort_a_
tortas64918253tort_as
tortrix1444193tortrix
tray77632593___tray
votary12248333vo_tary
vouvray1641933vouvray
workday1843303workday
worry116114333wor_r_y
worthy15598803wort_hy

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.403443402.0
2DLD Change Limit1340271437.15618729.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.62223444.1
 
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.