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

118 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
prisoning123764(None) 
poisoning1245901poisoning
crimsoning1542942crimsoning
imprisoning1652692imprisoning
prising103321452pris__ing
prissing113011452pris_sing
proponing1439992proponing
aproning11311793apr__oning
arising83619973aris__ing
brining103216473bri__ning
brisking15329473bris_king
brisling112410843bris_ling
bristling1246663bristling
caparisoning1772063caparisoning
crayoning1535243crayoning
crispening1543873crispening
crisping13319663cris_ping
crooning113112113cr_ooning
disowning1446113_disowning
droning93013723dr__oning
empoisoning1652133empoisoning
frisking16268363fris_king
frivoling1644493frivoling
garrisoning1352123garrisoning
grinning1037863gri_nning
irising83614423iris__ing
ironing82414013__ironing
lesioning1046443lesioning
lessoning1044773lessoning
masoning1139763_masoning
optioning1246553opti_oning
paining103920243pai__ning
paragoning1445953paragoning
pardoning1338763pardoning
peining104619153pei__ning
peising103416763peis__ing
pensioning1345913pensioning
perishing1539533peris_hing
phoning13312053p__honing
picoting1338883p_icoting
piloting1139693p_iloting
pining93726533p_i__ning
pinioning1246863pinioning
pinning103417853p_i_nning
pishing134314373p_is_hing
pissing103914803p_is_sing
pistoling1268493p_istoling
pivoting1436183p_ivoting
poising103617103pois__ing
portioning1347193portioning
praising113214563prais__ing
prawning1446963pr_awning
precoding15109733precoding
preening113115843pr_eening
presaging1339393presaging
prescoring1547433prescoring
presenting131013023presenting
preshowing1944473preshowing
presiding13510903presiding
presoaking1736253presoaking
presolving1644363presolving
presong1039843preso__ng
presorting1339983presorting
pressing112516443pres_sing
prestoring13310303prestoring
presuming1437663presuming
previsioning1884083previsioning
pricing123417343pri__cing
pricking173212603pri_cking
prickling1836533prickling
priding113317543pri__ding
priesting1239483priesting
prigging13299093pri_gging
prilling113413413pri_lling
priming123417373pri__ming
primming15268173pri_mming
primping15338893pri_mping
prinking153212453pri_nking
printing113216083pri_nting
prison8514023priso__n_
prisoned1138813prison_ed
prisoner1048573prison_er
prisoners1147373prisoners
prisons9313223priso__ns
pristine10313503pris_tine
prizing193514683pri__zing
probing123314443pr__obing
profaning1537293profaning
prologing1338953prologing
prolonging1444803prolonging
promoing13310463promo_ing
promoting1439923promoting
pronging123511843pr__onging
proofing1439313pr_oofing
propining14310133propining
proposing1439673proposing
prosing103319383pr__osing
proving134214073pr__oving
provisioning1883593provisioning
provoking1935133provoking
pruning10311733pr__uning
reasoning10310203reasoning
resining92919553_resining
resoling92916303_resoling
resowing123111523_resowing
rezoning18310453_rezoning
ribboning1443513_ribboning
rinning83216743_ri_nning
rioting82716393_ri_oting
ripening1138573_ripening
rising74025883_ris__ing
risking123914243_ris_king
rosining92411423_rosining
seasoning1037413seasoning
trining82919213tri__ning
uprising1138953upris__ing
visioning1347063_visioning
visoring1238373_visoring

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411188.06318434.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.57920828.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.