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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
prissily134669(None) 
brassily1336622brassily
crispily1574692crispily
dressily1246442dressily
friskily1834502friskily
grassily1236432grassily
pricily142710282pri_cily
priestly1345842priestly
prissier10157872prissier
prissies101712002prissies
prissing113011452prissing
prissy11347852priss__y
privily15207622pri_vily
prosily12611632pr_osily
riskily1436412_riskily
bossily1237563_bossily
briskly16165403bri_skly
bristly12178063bri_stly
classily1336623classily
crassly1276653crass_ly
crisply14426523cri_sply
crissal937413crissal_
crossly1277273cross_ly
crusily12199093cr_usily
crustily13328173crustily
drippily1643033drippily
drowsily1583723drowsily
feistily1445263feistily
fishily1637643_fishily
fissile10269653_fissile
flimsily1643283flimsily
flossily1434523flossily
frizzily2253143frizzily
frostily1436693frostily
fussily13267603_fussily
gassily1137813_gassily
glassily1235463glassily
glossily1235093glossily
greasily1236233greasily
grimily1336523gri_mily
grisly104310583gri_s_ly
gristly11187333gri_stly
grittily1244183grittily
grossly1175983gross_ly
messily12298813_messily
missile92815403_missile
missilry1344653_missilry
mistily122612343_mistily
mussily12279773_mussily
noisily1038403noi_sily
permissibly2052293permissibly
peskily1635083p_eskily
piosity1268643p_iosity
pissing103914803p_issing
pistil83915073p_istil_
pistils93314303p_istils
pithily1567033p_ithily
plushily1664423plushily
possibly1544483p_ossibly
preppily1444593preppily
pressing112516443pressing
pressingly1646003pressingly
prettily1337283prettily
prickly18367893pri_ckly
primarily1644673primarily
primely1457723pri_mely
primly13439623pri__mly
primsie1137543primsi_e
princely1545153princely
priority1347443priority
priorly12335763pri_orly
prising103321453pri_sing
priss74623893priss___
prissed103311263priss_ed
prisses94816713priss_es
prissiest11178903prissiest
pristine10313503pristine
pristinely1544793pristinely
privity15268313pri_vity
prossie91812953prossi_e
prossies101515223prossies
prussic1144743prussi_c
pursily1238213p_ursily
pushily15247983p_ushily
pussly11407373p_uss_ly
risibly1235643_risibly
rissole739783_rissole
ritzily1945143_ritzily
rosily93914713_r_osily
russify1334063_russify
rustily103112993_rustily
sassily1038723_sassily
scissile1044623scissile
springily1545583springily
tipsily1236043_tipsily
trashily1437323trashily
trickily1736233trickily
trustily11257103trustily
wispily1535653_wispily

Search took 8 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.420425454.8
2DLD Change Limit146162997.48319532.5
3Display Results99990.0501980.0
 (SQL Overall)178691997.95322468.4
 
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.