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

261 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
paraphs143931(None) 
paraph13311261paraph_
graphs124510152_graphs
palapas11311492palapas
parades104121462parades
parados103816052parados
paramos113213512paramos
parangs104314372parangs
parapet11317642parapet
parapets1239762parapets
paras76143042para__s
pardahs13289672pardahs
pariahs123812342pariahs
pharaohs1644492pharaohs
sarapes94617742sarapes
seraphs12408092seraphs
aahs716428563_a_a_hs
adapts9107813_adapts
agapes95212413_agapes
agrapha1345133agrapha
alephs1136533_alephs
amahs107819063_ama_hs
apropos1138843apropos
araks94820883_ara_ks
arames84622573_arames
arepas85515703_arepas
ataps76414833_atap_s
ayahs116813523_aya_hs
brachs134415753_brachs
caliphs1436753caliphs
canapes111213083canapes
caphs124515373__caphs
caracks152211563caracks
carafes125015703carafes
carapax1835793carapax
carates95630613carates
carats85929023cara_ts
carpals113414623carpals
carps96932253car_p_s
carpus105514303car_pus
ceriphs1484753ceriphs
crapes104727693_crapes
craps95328643_crap_s
curaghs1334583curaghs
diagraphs1644543diagraphs
digraphs15105753digraphs
drapes95419653_drapes
earache1239323earache
earaches13411303earaches
earlaps936393earlap_s
earths95014593ear_ths
eparchs14196243epar_chs
epigraphs1745043epigraphs
epitaphs1543233epitaphs
farads104713273fara_ds
fraps105620553_frap_s
galahs105512673gala_hs
garages9314113garages
garths104111503gar_ths
gerahs1039413gera_hs
grapes95123123_grapes
graph115315613_graph_
harass9313943hara_ss
harps105926873har_p_s
harumphs1841923harumphs
horahs126313873hora_hs
jalaps15299183jalap_s
jarrahs1735453jarrahs
kakapos1243673kakapos
kaliphs1634293kaliphs
kaphs144911503__kaphs
karates115617473karates
karats106420493kara_ts
khaphs18394323_khaphs
maracas11313773maracas
maras75443293mara__s
marauds1037553marauds
morphs13149433mor_phs
pacas96029403paca__s
padauks1443943padauks
paeans85118263paea_ns
pagans95717923paga_ns
pajamas18278153pajamas
palaces114216453palaces
palais8420423pala_is
palapa10310673palap_a
palates93624933palates
palps94719563pa_lp_s
palpus104210283pa_lpus
pampas124913993pa_mpas
panache1458423panache
panaches15310283panaches
panadas103312213panadas
panamas113112763panamas
papains11312363papains
papas94927493p__apas
papaws13419113papa_ws
papayas1437273papayas
pappus9408373pa_ppus
paps86443453p__ap_s
para65242173para___
parable111819773parable
parables121613563parables
parachor1546653parachor
parachors1647403parachors
parade94720643para_de
paraded114014263paraded
parader103914863parader
paraders113113113paraders
paradise112113873paradise
parador103311413parador
paradors113411903paradors
paradox17358173paradox
parae76335703para__e
paragon10311023paragon
paragons11311503paragons
paragraphs1844843paragraphs
paralyse1347483paralyse
paramo102614643para_mo
paramorphs1954253paramorphs
parang93715513para_ng
paranymphs2251453paranymphs
paraphrase1773533paraphrase
paraphyses2054743paraphyses
paraphysis2064533paraphysis
parashah1646453parashah
parashahs1744743parashahs
parashot13410143parashot
parasol939553parasol
parasols1039263parasols
parbakes1638343parbakes
parcels113712663parcels
parch125123003par_ch_
parches143720003parches
pardah123412823pardah_
pardons103817623pardons
pards85634333par__ds
parents93418123parents
pareos87023773par_eos
parers85530743par_ers
pares77164483par__es
pareses94718883pareses
paresis93315093paresis
pareus85420743par_eus
parfaits1346913parfaits
parges94529543par_ges
pargets105215193pargets
pargos95719043par_gos
pariah114320583pariah_
parians93519733parians
paries84742513par_ies
parings104219213parings
paris75145943par__is
parises94827183parises
parish115022353parish_
parishes13314753parishes
parkades1538273parkades
parkas125018023par_kas
parkers133816873parkers
parks116134463par__ks
parlays123910453parlays
parles86334403par_les
parleys125212373parleys
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
paroles95025883paroles
parols84722613par_ols
parous84024163par_ous
parrals94414573parrals
parrels94713493parrels
parries93925843parries
parrots9312743parrots
parrs75928673par__rs
pars67560793par___s
parsecs11429923parsecs
parsers94118153parsers
parses85534703par_ses
parsons93516873parsons
partakes1449923partakes
partans94418283partans
parties93230863parties
partons94620513partons
parts77743373par__ts
paruras9310533paruras
parures9512693parures
parvis116114803par_vis
parvos116614753par_vos
patacas11311003patacas
paths105521383p__aths
pavanes123612653pavanes
pavans115715593pava_ns
pawpaws1732823pawpaws
perhaps1446123perhap_s
periapts1237273periapts
perps95521483per_p_s
pharaoh1545033pharaoh_
phrases12711463phrases
piranas9912603piranas
piranha12126363piranha
piranhas13135873piranhas
pirates93020333pirates
pirayas1277483pirayas
praams10459643p_raams
prahu105013973p_ra_hu
prahus11458243p_rahus
prams96125513p_ra_ms
prangs94816233p_rangs
pranks124814723p_ranks
praos74923563p_ra_os
prases84429023p_rases
prates84633163p_rates
prats76333393p_ra_ts
praus74621753p_ra_us
prawns11509023p_rawns
praxes156215183p_raxes
praxis154012253p_raxis
prays105022433p_ra_ys
preps96220693p_rep_s
priapus1134353priapus
props95726883p_rop_s
pujahs18404943puja_hs
puranas9712643puranas
purdahs13285483purdahs
pyrans11411063pyra_ns
pyropes142210193pyropes
rajahs16497663raja_hs
ralphs1135373ra_lphs
rapes75740723__rapes
raphe104916423__raphe
raphes115117453__raphes
raphis114014323__raphis
raps66247733__rap_s
rayahs12579193raya_hs
sarans64224433sara_ns
sarape84817573sarap_e
satraps95011643satrap_s
scarphs14437413scar_phs
scrapes116217663scrapes
scraps106017243scrap_s
serapes95218103serapes
seraph114011163seraph_
staphs114411033_staphs
straps87721783strap_s
straths102711723straths
surahs94515543sura_hs
taramas9612703taramas
tarpans92513533tarpans
tarps76527113tar_p_s
teraph11319093teraph_
torahs95115643tora_hs
trapes85024463_trapes
traps75727483_trap_s
varas86028193vara__s
warmths1583783warmths
warpaths1643973warpaths
warps107126423war_p_s
watapes12228383watapes
wataps11248683watap_s
wraps105617153_wrap_s
wraths123810083_wraths

Search took 7 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.390458182.1
2DLD Change Limit1340272616.37621020.5
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.85926052.0
 
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.