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

53 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
praisers10341083(None) 
praiser93413941praiser_
praises94121101praise_s
raisers73617391_raisers
upraisers11174421upraisers
appraisers1443502appraisers
braiders114110572braiders
braises93818872braise_s
brasiers103710512brasiers
bruisers10307952bruisers
cruisers10438272cruisers
drainers92811252drainers
erasers74413942era_sers
fraises104215692fraise_s
grainers93012072grainers
kaisers11369272_kaisers
parises94827182parise_s
parsers94118152p_arsers
passers94717752p_assers
pausers94113222p_ausers
pavisers13387442pavisers
plaisters1137812plaisters
plaiters103512632plaiters
poisers94214432p_oisers
praise84419412praise__
praised104214812praise_d
prancers123210332prancers
prases84429022pra_se_s
praters94921652pra_ters
prawners1346002prawners
praxises1739062praxise_s
prayers124212852pra_yers
pressers103215022pressers
pricers113915062pr_icers
priers84521192pr_i_ers
primers114215672pr_imers
prisere9310942pr_isere
priseres10310822pr_iseres
prises84133172pr_ise_s
prizers183911842pr_izers
promisers13268202promisers
prosers94219642pr_osers
raiders84615142_raiders
railers74420662_railers
raiser66620102_raiser_
raises64826542_raise_s
rasers64526782_ra_sers
risers64624782_r_isers
trailers82912922trailers
trainers83114642trainers
upraiser10175842upraiser_
upraises10188472upraise_s
uprisers10206772upr_isers

Search took 5 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 Filter1786911210590.390458182.1
2DLD Change Limit121059533.79631891.2
3Display Results53530.0163312.5
 (SQL Overall)178691534.20242525.2
 
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.