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

86 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
phratry154374(None) 
phratral1344372phratral
phratric1545942phratric
barratry13114473barratry
bratty1159683_bratty
chantry15388223chantry
charry145012113ch_arry
chary135023133ch_a_ry
chatty14419363ch_atty
errantry11113463errantry
gharry13546273gh_arry
gyratory1544163gyratory
hairy115316833_h_airy
harry115322953_h_arry
hearty126313633_hearty
heathy156111213_heathy
hoary114516763_hoa_ry
horary12310383hora_ry
juratory1845183juratory
moratory1347823moratory
mortary12369043mortary
oratory1039403_oratory
paltry114910403p_altry
pantry115014103p_antry
parity114719873parit_y
parry105323753p__arry
partly116315473par_tly
party106630613par_t_y
pastry114913033p_astry
patly105020583p__atly
patsy105717203p__atsy
patty104723613p__atty
paty95234563p__at_y
peartly1267453peartly
peaty105725693p_eat_y
pedantry1444053pedantry
peltry11288653p_eltry
perjury19244253perjury
perry105222713per__ry
pertly115312553per_tly
phat95837863ph_at__
phatic133014413ph_atic
philtra12103683philtra
philtre12105213philtre
phorate12413363phorat_e
phorates13413043phorates
phrasal1246163phrasal
phrase11109903phra_se
phrased1387383phrased
phrases12711463phrases
phratries1447583phratries
phreatic1548343phreatic
phrensy1533623phrensy
physiatry2052203physiatry
piracy1339473pira_cy
pirate82322883pirat_e
pirated102515613pirated
pirates93020333pirates
piratic11314293piratic
platy105021663p_lat_y
podiatry1444353podiatry
poetry1139383p_oetry
portly114713403por_tly
portray1237483por_tray
potatory1348413potatory
poultry1235383poultry
prat65952043p_rat__
prate75135983p_rat_e
prated94924923p_rated
prater84825353p_rater
praters94921653p_raters
prates84633163p_rates
prats76333393p_rat_s
pray96331533p_ra__y
predry1237873p_redry
pretty11510873p_retty
priory114110263p_riory
psaltry12213803psaltry
purgatory1544413purgatory
purity114114913purit_y
purty105019403pur_t_y
ratty84819593__ratty
retry84718083__retry
theatre10358493theatre
throaty13428483throat_y
wrathy15377853_wrathy

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.423422437.4
2DLD Change Limit134027866.50020619.5
3Display Results86860.0302866.7
 (SQL Overall)178691866.95325699.8
 
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.