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

62 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
prythee154538(None) 
prithee1239931prithee
brothel12318193brothel
brother123311333brother
coryphee1874033coryphee
erythema1643483erythema
frothed14288783frothed
frother133110153frother
kythe15509673_kyth_e
kythed17407313_kythed
kythes16499133_kythes
lychee143710893_lychee
panther12611443panther
pattee84323383p_attee
payee105524723pay__ee
peytrel1264253peytrel
phytane1545443phytane
pithed124615613p_ithed
polythene1765043polythene
potheen12257893p_otheen
pother113818853p_other
prate75135983prat__e
prated94924923prat_ed
prater84825353prat_er
prates84633163prat_es
prattle9208833prattle
pree67044733pr___ee
pretape113511623pretape
preteen939873preteen
pretype14387483pretype
pretzel1835143pretzel
prophet14316033prophet
protea82214763prot_ea
protege1059153protege
protegee1156963protegee
protei82615313prot_ei
protheses1449073protheses
protyle12229453protyle
pryer104415313pry__er
psyche1674293psych_e
psyched1843913psyched
psyches1755803psyches
puttee85919723p_uttee
python1447143p_ython
rathe85821923_rath_e
rather94319743_rather
rushee93818773_rushee
scythe14466013scyth_e
scythed16385303scythed
scythes15356523scythes
thee78039063___thee
trochee122613883trochee
trothed114010973trothed
tythe115210453_tyth_e
tythed13457503_tythed
tythes12419703_tythes
wrathed14298523wrathed
writhe125310703writh_e
writhed14389623writhed
writhen13407863writhen
writher134010853writher
writhes134811703writhes

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 Filter1786911340270.390458182.1
2DLD Change Limit134027626.23621492.5
3Display Results62620.0302066.7
 (SQL Overall)178691626.65626846.6
 
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.