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

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

64 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
princes11301514(None) 
prances113618771prances
prices104524541pri_ces
prince104114761prince_
princess12266801princess
brines85028852brin_es
brinies93317912brinies
coprinces1547482coprinces
cringes103215502cringes
evinces1237802evinces
fringes113514102fringes
grinches1436952grinches
minces104420802_minces
painches1588912painches
pieces104217272p_ieces
pincer104019172p_incer
pincers113916502p_incers
pinches144117932p_inches
pines76048862p_in_es
pointes93216752pointes
ponces104720842p_onces
pounces114113892pounces
prance104318572prance_
pranced123714042pranced
prancer113613382prancer
prancers123210332prancers
price93725412pri_ce_
priced115018882pri_ced
pricer103918292pri_cer
pricers113915062pri_cers
pricey134412632pri_cey
pricks144414262pri_cks
prides94324182pri_des
pries74339532pri__es
primes104225262pri_mes
princely1545152princely
princesse13264402princesse
princox1843572princox
princoxes2044082princoxes
prinked143412162prinked
prinker133412742prinker
prinkers143010382prinkers
prinks124315382prin_ks
printed104016372printed
printer93917302printer
printers103214902printers
prints84320102prin_ts
prises84133172pri_ses
prisses94816712prisses
privies122414262privies
prizes173819812pri_zes
provinces1646852provinces
prunes83419062prun_es
purines94420762purin_es
quinces183210432quinces
rances84625442_rances
rices75536152_ri_ces
rinses64720382_rinses
springes114014032springes
trances93919642trances
trices84826332tri_ces
trines64132562trin_es
urines64724122urin_es
winces114819112_winces

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 Filter1786911076710.796224486.2
2DLD Change Limit107671646.68616103.9
3Display Results64640.0461391.3
 (SQL Overall)178691647.52823736.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.