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

256 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
phorates1341304(None) 
ephorates1459161ephorates
phonates13410641phonates
phorate12413361phorate_
prorates10418071prorates
apholates1449682apholates
borates94823012_borates
chlorates142512272chlorates
cholates132414762cholates
chorales133712882chorales
chordates1547682chordates
ephorate1359502ephorate_
horstes104516112_horstes
orates64328612__orates
perorates11417022perorates
phenates13611582phenates
phonate12411812phonate_
phonated1447892phonated
phrases12711462ph_rases
picrates122013212picrates
pirates93020332p_irates
prates84633162p__rates
priorates11410762priorates
probates12414282probates
pronates10418372pronates
prorate9418732prorate_
prorated11513712prorated
thoraces13118942thoraces
thoraxes1896362thoraxes
thorites11312392thorites
aerates74627493_aerates
amirates101114793amirates
apholate13410473apholate_
aphorises14310003aphorises
aphorizes2348013aphorizes
berates94126873_berates
boraces113716853_boraces
borages103917163_borages
boranes93720403_boranes
borate85026153_borate_
borated104116363_borated
boraxes163511633_boraxes
bromates12413143bromates
camphorates20124763camphorates
carates95630613_carates
cerates95428253_cerates
charades141310853charades
charases131312763charases
chelates132713843chelates
chlorate133112693chlorate_
chlorites142311963chlorites
cholate122114933cholate_
choragus1474303choragus
chorale124313353chorale_
chorals124614113chora_ls
chordate1448033chordate_
chores114828023chor__es
chorines132917253chorines
chorten122811303chor_ten
chortens13308793chor_tens
chortles133611323chortles
choruses1339983choruses
chromates16313113chromates
citrates102315093citrates
cohobates1646523cohobates
comates114123643_comates
crates85736063__crates
curates95323833_curates
decorates12314743decorates
derates84028893_derates
diorites9313523diorites
disrates91118153disrates
donates83217223_donates
emirates101214853emirates
ferrates113013423ferrates
folates103218453_folates
forages114217283_forages
formates132814293_formates
fortes95327183_for_tes
gheraoes1244813gheraoes
grates75429893__grates
gyrates113610263_gyrates
hamates122917683_hamates
hates86742573_h__ates
hoaxes163611693_ho_axes
homages131011593_homages
horahs126313873_hora_hs
horas86333103_hora__s
hordes104921633_hor_des
hornets104113553_hornets
horses94729353_hor_ses
horste94817413_horste_
horsts95817513_horst_s
humates122813193_humates
hydrates15229413hydrates
hyraces1537913_hyraces
hyraxes2045703_hyraxes
ingrates9514173ingrates
iodates8312903_iodates
isolates8613513isolates
iterates81317823iterates
karates115617473_karates
khanates1535733khanates
korats105416063_korat_s
librates103412953librates
locates93218813_locates
migrates111112853migrates
misrates101318243misrates
moorages1139053moorages
morales93619403_morales
narrates8312763narrates
neonates8310063neonates
niobates1037283niobates
nitrates82516223nitrates
norites74018803_norites
notates72817483_notates
odonates947743odonates
operates10515413operates
orate55133303__orate_
orated74221503__orated
outrates82421373outrates
ozonates1745963ozonates
palates93624943p_alates
palpates122613063palpates
parades104121463p_arades
pastorates12410153pastorates
pates76047893p___ates
patriates11311363patriates
pectates122213953pectates
peerages1189893peerages
penates93321603p_enates
peonages1138473peonages
perborates1459213perborates
perforates1558863perforates
perorate10417923perorate_
perorated12412463perorated
petrales10312983petrales
phages125213513ph__ages
pharaohs1644493pharaohs
pharoses13310313pharoses
phases114618403ph__ases
phenate12412203phenate_
phenolates1547023phenolates
phereses1348093phereses
phoebes1435813pho_ebes
phonemes1546193phonemes
phones114121213pho__nes
phonies123717513pho_nies
phoresies1447993phoresies
phoresy1534653phor__esy
phosphates2087163phosphates
photos113316643pho__tos
phots105418503pho__t_s
phrase11109903ph_rase_
phrased1387383ph_rased
phratries1447583ph_ratries
phratry1543743ph_ratry
phytanes1645763phytanes
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirate82322883p_irate_
pirated102515613p_irated
placates12311753placates
plates85432243p__lates
podites103014733p_odites
pointes93216753p_ointes
pomaces132712123p_omaces
pomades123711733p_omades
pontes83627853p_o_ntes
porches143815673p_orches
pores75849033p_or__es
porgies103017003p_orgies
porkies133416493p_orkies
portages112613223p_ortages
portals94015563p_ortals
ported94223243p_or_ted
porter84224413p_or_ter
porters93722703p_or_ters
ports75934593p_or_t_s
potages102416423p_otages
potatoes1039943p_otatoes
prases84429023p__rases
prate75135983p__rate_
prated94924923p__rated
prater84825353p__rater
praters94921653p__raters
prats76333393p__rat_s
praxes156215183p__raxes
predates11615813predates
prelates10418573prelates
primates121515933primates
priorate10411733priorate_
privates131812373privates
probate11414483probate_
probated13410863probated
procreates1448153procreates
proettes10312763proettes
profanes132311573profanes
prolate9419793prolate_
promotes12314123promotes
pronate9418873pronate_
pronated11414053pronated
propanes122415823propanes
prorogates1347313prorogates
prostates11314423prostates
prostrates12411993prostrates
protases102115033protases
psoralea1083433psoralea
psoraleas1172863psoraleas
psoralen1063453psoralen
psoralens1182823psoralens
psoriases1144863psoriases
pulsates1048813pulsates
pupates113311433p_upates
pyrites12812203p_yrites
rates55352013___rates
recrates102420373recrates
regrates92618403regrates
rotates72819773_rotates
serrates82617023serrates
shoats94117083sho_at_s
shorans102812413shora_ns
shores94830413shor__es
shortages1336513shortages
shorted113614403shor_ted
shorten103511413shor_ten
shortens11288993shor_tens
shorter103515503shor_ter
shortest11310783shor_test
shorties11414583shorties
shorts95321743shor_t_s
shotes95321913sho__tes
solates73523853_solates
sorbates10311103_sorbates
sorites73825243_sorites
sororates9410473sororates
stomates10313343stomates
storages9311103storages
storaxes1536883storaxes
thionates12106663thionates
thorite10313443thorite_
thorpes125010353thor_pes
thraves13469713th_raves
throated1247923throated
throats104612193throat_s
titrates82314663titrates
tortes64826053_tor_tes
uncrates10314563uncrates
uprates93814863_uprates
urates65027763__urates
vibrates132210613vibrates
violates11311193violates
whores125617103whor__es
whortles14306743whortles
whorts125111433whor_t_s

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.420425454.8
2DLD Change Limit1461622566.86021306.4
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.37324235.9
 
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.