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

420 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
puisne85635(None) 
puisnes937421puisnes
cuisine9310422cuisine
cuisse8318332cuisse
guise64717712guis_e
paise75028332pais_e
peise75825772peis_e
pine67755712p_i_ne
piste75824602p_iste
plisse8368402plisse
poise75127892pois_e
prise74632612pris_e
pulse74219972puls_e
purine85321892purine
purse76028892purs_e
pursue84512252pursue
rusine63916592rusine
aisle55223193_aisle
aline57243153ali_ne
amine75835383ami_ne
anise55129703anis_e
arise56436433aris_e
arisen65316793arisen
arsine64021043arsine
azine146721413azi_ne
beigne9148613beigne
bine66650863_bi_ne
bise66437103_bis_e
brine75132273bri_ne
bruise83412873bruis_e
bursae84515603bursae
burse75527253burs_e
busing96420593busing
butane8313653butane
butene8312623butene
chine105231723chi_ne
cine66242943_ci_ne
cline76428533cli_ne
coigne94612193coigne
cosine83823513cosine
cruise84314043cruis_e
cuing85420193cui_ng
cuish10313173cuis_h
cuishes122810823cuishes
cuisines1049373cuisines
cuisses9319883cuisses
curse75829143curs_e
diene65720133_diene
dine55555333_di_ne
disme85716243_disme
dulse65415043duls_e
dune56137583du__ne
dwine95616143dwi_ne
enisle63412093enisle
eosine64519413eosine
equine151711573equi_ne
esne47018793__esne
exine125518493exi_ne
fine75147953_fi_ne
frise85322453fris_e
frisee94217993frisee
furane94015493furane
fuse76429993fu_s_e
fusee86224583fu_see
fusile94313493fusile
fusing104415953fusing
guide75019883gui_de
guile64521133gui_le
guimpe1134723guimpe
guinea737613gui_nea
guised84612173guised
guises74216313guises
guising93511413guising
gussie72910153gussie
gwine95513663gwi_ne
hisn79620933_hisn_
hoise85224773hois_e
humane112812173humane
imine75821063imi_ne
isle45121703__isle
juice14311323jui_ce
kine85643423_ki_ne
koine9516483koi_ne
kune85424573ku__ne
liane54720663_liane
line46965573_li_ne
lisle53916723_lisle
lune47140493lu__ne
lupine84013533lupine
lysine94210553lysine
mesne75116293_mesne
mine67256163_mi_ne
mise66043583_mis_e
murine84220023murine
muse67136033mu_s_e
musing93919503musing
mutine84420373mutine
nine45842173_ni_ne
noise55723733nois_e
nuisance1045703nuisance
nurse54420123nurs_e
opine77422463opi_ne
outsee63121803outsee
ovine86316643ovi_ne
pain65647243pai_n_
pained95622853pai_ned
pains75138283pai_ns
paint75443693pai_nt
paisa76021073pais_a
paisan84417073paisan
paisana94010223paisana
paisano9429513paisano
paisans93614753paisans
paisas84317493paisas
paisley1235553paisley
pane64950283p__ane
panne76623653p_anne
parse75236993pars_e
pase65346863p_as_e
passe75525693p_asse
passee84522023passee
paste74932953p_aste
patine85328123patine
pause75021833paus_e
pausing103912813pausing
pavane114113443pavane
pavise114714803pavis_e
pavisse12546813pavisse
pease75231113peas_e
peasen84815953peasen
pein65834943pei_n_
peined94918843pei_ned
peins76128063pei_ns
peised94817683peised
peises84125043peises
peising103416763peising
pelisse967063pelisse
penne75423853p_enne
pensee8417313pensee
pepsine11310603pepsine
perse75429523pers_e
phase104617213phas_e
phis95724903phis__
phone105621933p_hone
pian66136093p_ian_
piano76118713p_iano
pians75126963p_ians
pice84641093p_i_ce
pie55457403p_i__e
piece96717993p_iece
pigsney1342873pigsney
piing85218833p_iing
pike106335213p_i_ke
pile65649693p_i_le
pilsner935343pilsner
pin57066723p_i_n_
pina65842633p_i_na
pined85935323p_i_ned
pinene82915643pinene
pines76048863p_i_nes
piney105727503p_i_ney
ping75943593p_i_ng
pink107039383p_i_nk
pinna75320183p_inna
pinnae84414643p_innae
pinned94818383p_inned
pinner84521503p_inner
pinny105222063p_inny
pins65558453p_i_ns
pint66963173p_i_nt
piny911838353p_i_ny
pion67235293p_ion_
pions75826393p_ions
pipe86434433p_i_pe
pique16410173p_ique
pirn67128373p_irn_
pirns76020093p_irns
pis56362033p_is__
piscine11610973p_iscine
pisco96314983p_isco
pish96127913p_is_h
pished124817063p_ished
pisher114317753p_isher
pishes114722103p_ishes
piso66727563p_is_o
pisos76021063p_isos
piss65033333p_is_s
pissed94816933p_issed
pisser84416383p_isser
pisses84525083p_isses
pistes85325633p_istes
pixie145415523p_ixie
plane74929143p_lane
pliant83918823pliant
plicae10410953plicae
plie65127393pli__e
plink115219123pli_nk
pliskie1394543pliskie
plisky1533713plisky
plisses94411773plisses
poind84217913poi_nd
point75338733poi_nt
pointe84619313pointe
pois66539043pois__
poised94918473poised
poiser84217243poiser
poises84226543poises
poisha1135723poisha
poising103617103poising
poison8312223poison
poisoned1136953poisoned
poisoner1046983poisoner
poisons9310353poisons
pone65747533p__one
popsie103013053popsie
pose66441733p_os_e
posing93922643posing
posse74722273p_osse
potsie83916023potsie
poussie936623poussie
poutine93316823poutine
praise84419413prais_e
prase76128753pras_e
prese75228383pres_e
price93725413pri_ce
pride84724733pri_de
prime96525603pri_me
primine113214823primine
primsie1137543primsie
prince104114763prince
prink114719673pri_nk
print74837463pri_nt
prion75119993prion_
prions84317783prions
prised94322203prised
prisere9310943prisere
prises84133173prises
prising103321453prising
prism94820263pris_m
prisms104915503prisms
prison8514023prison
prisoned1138813prisoned
prisoner1048573prisoner
prisons9313223prisons
priss74623893pris_s
prissed103311263prissed
prisses94816713prisses
prissy11347853prissy
pristane10310333pristane
pristine10313503pristine
prize164718943pri_ze
prone75332623p_rone
prose75835123pros_e
prune75119633p_rune
psis68120343psis__
ptisan8417973ptisan
ptisans9317363ptisans
pubis94616473pubis__
pubs85029213pubs__
puce85127883pu__ce
puddle103914153puddle
puds75630513puds__
pugree92112473pugree
pugs76332773pugs__
puissance1343783puissance
puissant10105393puissant
puke105025463pu__ke
puking133913063puking
pule65040953pu__le
pulicene1245713pulicene
puling93621403puling
pulis74225603pulis__
pulque1736213pulque
puls65437563puls__
pulsant9310563pulsant
pulsar8329363pulsar
pulsate9510233pulsate
pulsed94013723pulsed
pulser84215193pulser
pulses83818663pulses
pulsing103712863pulsing
pumice1238223pumice
pun58846513pu__n_
puna65331653pu__na
pung75429633pu__ng
pungle94413573pungle
punish111411503punis_h
punished1436043punished
punisher1335773punisher
punishes1338113punishes
punk105729973pu__nk
punkie123513613punkie
punned93416193pu_nned
punner84918153pu_nner
punnet83518843pu_nnet
punny104217713pu_nny
puns66641483pu__ns
punster92911103punster
punt65747203pu__nt
puny95526993pu__ny
pupae96515643pu_pae
pupate104213123pupate
pups86032233pups__
purana8712933purana
pure65543333pu__re
puree74632843pu_ree
purfle112511183purfle
purge85324603pu_rge
purin75527593purin_
purines94420763purines
purins83722653purins
puris75332023puris__
purism104715063puris_m
purisms114110833purisms
purist85525053puris_t
purists94014073purists
purline93516533purline
purple102712673purple
purs65641043purs__
pursed95220883pursed
purser85020473purser
purses84826373purses
pursier94012753pursier
pursing103715553pursing
purslane1045783purslane
pursued10388133pursued
pursuer9338893pursuer
pursues94111373pursues
pursy105016413purs_y
pus55547843pu_s__
puses75532203pu_ses
push95526623pu_s_h
pushed125017463pu_shed
pusher114318283pu_sher
pushes114621663pu_shes
pushy134614353pu_shy
pusley11379613pu_sley
puss64830133pu_s_s
pusses84322843pusses
pussier93711993pussier
pussies93615693pussies
pussley12375123pussley
pussly11407373pussly
pussy105614843pu_ssy
puton73617913puton_
putons83515153putons
puts65641753puts__
putsch1334933putsch
puttee85919723puttee
puttie84116303puttie
puzzle16318603puzzle
pyin96823233pyi_n_
pyins105815863pyi_ns
pyrene113210733pyrene
pyrone112714473pyrone
quiche2057903quiche
quin135823923qui_n_
quince173910133quince
quinine163011043quinine
quinone16217463quinone
quins144819853qui_ns
quinsy18386353quinsy
quint144529903qui_nt
quinte153414523quinte
quire144917123qui_re
quite144621463qui_te
raise54828053rais_e
rinse54820973_rinse
rise45945233_ris_e
risen54621883_risen
ruin47430513rui_n_
ruined74813323rui_ned
ruiner64013643rui_ner
ruing67221053rui_ng
ruins55822033rui_ns
rune45236293ru__ne
ruse45938933ru_s_e
seine55732873sei_ne
seise54727853seis_e
shine85533093shi_ne
sine46560623_si_ne
soigne74310033soigne
speise84614253speis_e
spine76534423spi_ne
spline86020533spli_ne
spuing94313363spui_ng
spumone1154383spumone
suing65026363sui_ng
suint55638183sui_nt
suite54829563sui_te
supine84216693supine
swine85625303swi_ne
thine85026853thi_ne
tine45855133_ti_ne
tisane6311573_tisane
triene64316383triene
trine54734603tri_ne
triste63818643triste
triune64210183triune
tuille63012643tuille
tuis44829643tuis__
tune45635863tu__ne
tussle637143tussle
twine85822363twi_ne
uprise82313693upris_e
uprisen9227353uprisen
upside9289803upside
upsize17267303upsize
urine55026593_urine
ursae55214453_ursae
ursine64114123_ursine
use36835163_u_s_e
using66317963_using
usnea539393_u_snea
vine75643683_vi_ne
vise75632673_vis_e
whine116022813whi_ne
wine74953423_wi_ne
wise75737343_wis_e
zine137036153_zi_ne

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164205.23321539.5
3Display Results4204200.2201909.1
 (SQL Overall)1786914205.59331949.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.