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

123 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
prisoner104857(None) 
poisoner1046981poisoner
prisoned1138811prisoned
prisoners1147371prisoners
coprisoner1453562coprisoner
poisoned1136952poisoned
poisoners1146112poisoners
prison8514022prison__
prisons9313222prison_s
prissier10157872prissier
briner84519043bri__ner
brisker134210293bris_ker
coprisoners1553113coprisoners
crayoner1344853crayoner
crimsoned1443803crimsoned
crisper113511053cris_per
crispier12297253crispier
crooner93714043cr_ooner
droner74717673dr__oner
frisker14389273fris_ker
friskier1535193friskier
frivoler1443933frivoler
grinner8329233gri_nner
grislier935793grislier
grison7310103grison__
grisons838993grison_s
grister83915413gris_ter
imprisoned1552943imprisoned
ironer64216453__ironer
isomer8310153__isomer
kroner104612573kr__oner
orison6411663orison__
orisons7310563orison_s
pardoner11189443pardoner
parishioner1651903parishioner
passover13135533passover
pensioner1146663pensioner
peritonea1147303peritonea
pilsener1044753pilsener
pilsner935343p_ilsner
pinner84521503p_i_nner
pinones94717073p_inones
pioneer936893p_i_oneer
pisher114317753p_is_her
pisser84416383p_is_ser
poiser84217243pois__er
poison8312223poison__
poisons9310353poison_s
portioner1158683portioner
praiser93413943prais__er
prawner1246803pr_awner
preener93114833pr_eener
presager1138443presager
presenter11311643presenter
presider11410423presider
presong1039843preson_g
presser93717623pres_ser
prester93519623pres_ter
presumer1247583presumer
pricer103918293pri__cer
pricier113313113pri_cier
pricker154013413pri_cker
prickier16368143prickier
prier75027763pri___er
primer105118683pri__mer
primine113214823primine_
primines123013703primines
primmer134310163pri_mmer
prinker133412743pri_nker
printer93917303pri_nter
prion75119993pri_on__
prions84317783pri_on_s
prior74316173pri_o__r
prise74632613pris__e_
prised94322203pris__ed
prisere9310943pris__ere
priseres10310823priseres
prises84133173pris__es
prising103321453prisin_g
prisoning1237643prisoning
prissed103311263pris_sed
prisses94816713pris_ses
prissies101712003prissies
pristane10310343pristane_
pristanes11410433pristanes
pristine10313503pristine_
privater13158533privater
privier122910453pri_vier
prizer174714883pri__zer
prober104516073pr__ober
profaner13197943profaner
prolonger12305873prolonger
promoter12311453promoter
prone75332623pr__one_
proofer12149103pr_oofer
proper104319953pr__oper
propone112716303propone_
proponed132412033proponed
propones122516963propones
proposer121810633proposer
proser84223463pr__oser
prosier93817483pros_ier
prosper114012193pros_per
prover113819723pr__over
provisioner1653793provisioner
provoker1784913provoker
prower114218123pr__ower
pruner83413453pr__uner
puisne856353puis_ne_
puisnes937423puis_nes
reasoner849343reasoner
rioter64817283_ri_oter
ripener937903_ripener
riser55431053_ris__er
risker105414493_ris_ker
riskier1138423_riskier
seasoner857693seasoner
trisome9310223trisome_
trisomes1039833trisomes
tritone73613883tritone_
tritones83413443tritones
upriser9218763upris__er
wristier1136863wristier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621236.62622058.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.82826170.3
 
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.