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

155 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
prisoned113881(None) 
poisoned1136951poisoned
prisoner1048571prisoner
crimsoned1443802crimsoned
imprisoned1552942imprisoned
poisoner1046982poisoner
prised94322202pris__ed
prison8514022prison__
prisoners1147372prisoners
prisons9313222prison_s
prissed103311262pris_sed
proponed132412032proponed
aproned10311503apr__oned
brined95118413bri__ned
brisked144210003bris_ked
bristled11187343bristled
caparisoned1691753caparisoned
coprisoner1453563coprisoner
crayoned1435003crayoned
crisped124010103cris_ped
crispened1443613crispened
crooned103813343cr_ooned
disowned1336433_disowned
droned84616863dr__oned
empoisoned1552293empoisoned
frisked15478823fris_ked
frivoled1534043frivoled
garrisoned1242283garrisoned
grinned9378553gri_nned
grison7310103grison__
grisons838993grison_s
irised73913153iris__ed
ironed74916013__ironed
lesioned936903lesioned
lessoned945393lessoned
masoned1039803_masoned
optioned1146383opti_oned
orison6411663orison__
orisons7310563orison_s
pained95622853pai__ned
paragoned1357063paragoned
parasoled1246353parasoled
pardoned12189333pardoned
peined94918843pei__ned
peised94817683peis__ed
pennoned1136313pennoned
pensioned1246653pensioned
perished14310083peris_hed
peritonea1147303peritonea
phoned124014553p__honed
picoted1239213p_icoted
piloted10310323p_iloted
pined85935323p_i__ned
pinioned1137513pinioned
pinned94818383p_i_nned
pinones94717073p_inones
pished124817063p_is_hed
pissed94816933p_is_sed
pistoled11259593p_istoled
pivoted1336513p_ivoted
poised94918473pois__ed
poison8312223poison__
poisoners1146113poisoners
poisons9310353poison_s
portioned1248333portioned
praised104214813prais__ed
prawned1346743pr_awned
precoded1438863precoded
preened103214993pr_eened
preowned1435213preowned
presaged1238803presaged
prescored14409403prescored
presented12311633presented
preshowed1875183preshowed
presided12410553presided
presoaked1635653presoaked
presold1059603preso_ld
presolved1545273presolved
presong1039843preson_g
presorted1239453presorted
pressed103317313pres_sed
prestored125111673prestored
presumed1337973presumed
previsioned1744263previsioned
priced115018883pri__ced
pricked164613833pri_cked
prickled17358073prickled
prided103618033pri__ded
pried84426863pri___ed
priested1138393priested
prigged12398933pri_gged
prilled104713003pri_lled
primed115118913pri__med
primine113214823primine_
primines123013703primines
primmed14388853pri_mmed
primped14479153pri_mped
prinked143412163pri_nked
printed104016373pri_nted
prion75119993pri_on__
prions84317783pri_on_s
prise74632613pris__e_
prisere9310943prisere_
priseres10310823priseres
prises84133173pris__es
prising103321453prisin_g
prismoid1344983prismoid
prisoning1237643prisoning
prisses94816713pris_ses
prissier10157873prissier
prissies101712003prissies
pristane10310343pristane_
pristanes11410433pristanes
pristine10313503pristine_
prized184415393pri__zed
probed114114823pr__obed
profaned14207973profaned
prologed12189213prologed
prolonged13285413prolonged
promoed12310083promo_ed
promoted13310543promoted
prone75332623pr__one_
pronged113912393pr__onged
proofed13138723pr_oofed
propined133111503propined
propone112716303propone_
propones122516963propones
proposed132011073proposed
prosed94921093pr__osed
proved125016033pr__oved
provisioned1753973provisioned
provoked1875053provoked
pruned93413113pr__uned
puisne856353puis_ne_
puisnes937423puis_nes
reasoned9410733reasoned
resined84522653_resined
resoled84119283_resoled
resowed113712253_resowed
rezoned173611163_rezoned
ribboned1343973_ribboned
rioted73416373_ri_oted
ripened1038203_ripened
risked115514633_ris_ked
rosined84911903_rosined
seasoned948113seasoned
trilobed1144203trilobed
trined74920713tri__ned
trisome9310223trisome_
trisomes1039833trisomes
tritone73613883tritone_
tritones83413443tritones
unironed939083unironed
visioned1247013_visioned
visored1138143_visored

Search took 9 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.436409841.7
2DLD Change Limit1461621557.87318565.0
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.37221343.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.