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 “padis” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

211 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
padis8622714(None) 
cadis84428491cadis
gadis74825291gadis
kadis105921061kadis
padi76331781padi_
pads76742951pad_s
paris75145941paris
pavis106422731pavis
qadis155917851qadis
sadis64930851sadis
wadis95223961wadis
adds67622452_adds
adios65822862_adios
adit56443652_adit
adits66523712_adits
ados57633512_ados
ads49755732_ad_s
ahis76135382_ahis
aids57846352_aids
ais39083572_a_is
amis66445322_amis
anis45746462_anis
aphis105917132aphis
apsis75718292apsis
axis116127912_axis
bads77048862bad_s
basis75429862basis
bidis86721142bidis
caddis104613372caddis
cades85440732cades
cadi75732172cadi_
cads76144522cad_s
caids85226422caids
cedis84317082cedis
dadas75819862dadas
dados75522432dados
dads67442772dad_s
dais57040702da_is
dis46459892__dis
fades94932862fades
fados95620732fados
fads86939872fad_s
gaddis94211372gaddis
gadi66329722gadi_
gadid85517372gadid
gadids95611822gadids
gads67843382gad_s
hades96035112hades
hadjis17439632hadjis
hajis156716272hajis
jades135222112jades
jadish17319902jadish
kadi96224822kadi_
kakis86116842kakis
khadis1446912khadis
lades65141272lades
ladies75124882ladies
lads56549132lad_s
lapis76223152lapis
laris54737462laris
mads76845362mad_s
maids86327142maids
mavis105622722mavis
maxis145721562maxis
midis85923412midis
nabis76020582nabis
nadas66320812nadas
nadir61012972nadir
nadirs7109002nadirs
naris55735292naris
nazis145216082nazis
oasis56422552oasis
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
pad68057322pad__
paddies113715722paddies
paddy125913592paddy
padle84522342padle
padles95221112padles
padre86018162padre
padres95016982padres
padri85815162padri
pages85235072pages
paid75737482pa_id
paik105726802pa_ik
paiks114719852paiks
pail66141832pa_il
pails75833062pails
pain65647242pa_in
pains75138282pains
pair66031512pa_ir
pairs75325832pairs
paisa76021072pa_isa
paise75028332pa_ise
palais8420422palais
pales75753802pales
palish114718272palish
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
pandas95521962pandas
pandies104224502pandies
pandit93820752pandit
pandits103914212pandits
panes76148692panes
pangs84628662pangs
panic93923902panic
panics103815362panics
pans65855722pa_ns
pants76536922pants
papas94927492papas
papism122211512papism
papist102618742papist
paps86443452pa_ps
paras76143042paras
pardi85723952pardi_
pardie96021442pardie
pards85634332pards
pares77164482pares
paries84742512paries
parish115022352parish
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
parvis116114802parvis
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pastis84924322pastis
pasts75936502pasts
pates76047892pates
paths105521382paths
patin76832852patin
patins87528782patins
patio74426352patio
patios85221782patios
patois84319362patois
pats66460852pa_ts
paves104833922paves
pavid115717002pavid
pavin105623202pavin
pavins114919662pavins
pavise114714802pavise
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
pedes85327282pedes
peds75835242ped_s
penis75129322penis
peris75537072peris
phasis114614922phasis
phis95724902p_his
pikis115116392pikis
pilis75825202pilis
pis56362032p__is
plaids94312442plaids
podia8415282podia
pods76540152pod_s
pois66539042p_ois
polis74731162polis
praxis154012252praxis
psis68120342p_sis
pubis94616472pubis
pudic104614562pudic
puds75630512pud_s
pulis74225602pulis
puris75332022puris
pyxis17458632pyxis
qadi145621102qadi_
qaids156116312qaids
radii64016412radii
radio64922492radio
radios74018672radios
radish103516912radish
radius73914862radius
radix134414592radix
rads56046602rad_s
ragis66325602ragis
raids65827512raids
rais45252622ra_is
rakis95323442rakis
ranis55235832ranis
sades65239892sades
sadi55834642sadi_
sadism94113492sadism
sadist74221352sadist
saids65328852saids
sakis95323662sakis
saris54544952saris
satis55633672satis
spades94222582spades
spadix1636102spadix
spahis11310382spahis
tads57143942tad_s
tamis76728722tamis
tapis75028862tapis
taxis126821972taxis
tsadis7429132tsadis
wades95634142wades
wadi86228172wadi_
wadies105121202wadies
wads87343142wad_s
yagis95416572yagis

Search took 2 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 Filter178691538000.0762351197.4
2DLD Change Limit538002111.70331591.3
3Display Results2112110.0633349.2
 (SQL Overall)1786912111.84297009.2
 
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.