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

95 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
praises9412110(None) 
braises93818871braises
fraises104215691fraises
parises94827181parises
praise84419411praise_
praised104214811praised
praiser93413941praiser
praisers103410831praisers
prases84429021pra_ses
praxises1739061praxises
prises84133171pr_ises
raises64826541_raises
upraises10188471upraises
appraises1347422appraises
arises65233802ar_ises
arrises71617582arrises
braise84318752braise_
braised104014802braised
braizes183112452braizes
brasses93818352brasses
brises84927612br_ises
bruises93212912bruises
chaises124317492chaises
crases85532312cra_ses
crises84529432cr_ises
cruises93514442cruises
daises74318982_daises
erases64425402era_ses
fraise94214912fraise_
frasses104314512frasses
frises94124272fr_ises
grasses84117342grasses
irises64221172ir_ises
krises105016082kr_ises
liaises7311052liaises
orrises71312232orrises
paisas84317492p_aisas
paise75028332p_aise_
paradises122513202paradises
pareses94718882pareses
paries84742512pari_es
parishes13314752parishes
parses85534702p_arses
parvises133911912parvises
pases75346502p_a_ses
passes86030472p_asses
pauses84621472p_auses
pavises125315492pavises
peases85229472pea_ses
peises84125042p_eises
penises9318192penises
phases114618402pha_ses
phrases12711462phra_ses
plaices11411142plaices
poises84226542p_oises
practises1349622practises
prairies10411452prairies
pralines102217722pralines
prances113618772prances
prase76128752pra_se_
prates84633162pra_tes
praxes156215182pra_xes
precises123218332precises
premises123018272premises
presses93523152presses
previses133814282previses
prices104524542pr_ices
prides94324182pr_ides
pries74339532pr_i_es
primes104225262pr_imes
prise74632612pr_ise_
prised94322202pr_ised
prisms104915502pr_isms
priss74623892pr_is_s
prisses94816712prisses
prizes173819812pr_izes
promises122916762promises
proses84733472pr_oses
prosses94019512prosses
raise54828052_raise_
raised76120332_raised
raiser66620102_raiser
raisers73617392_raisers
rases55447212_ra_ses
reraises8415642reraises
rises55244042_r_ises
traipses1036872traipses
trasses74819322trasses
upraise9158602upraise_
upraised11167412upraised
upraiser10175842upraiser
upraisers11174422upraisers
uprises92012732upr_ises
urases63723562ura_ses
wrasses103812592wrasses

Search took 4 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.373479064.3
2DLD Change Limit107671953.12634443.7
3Display Results95950.0332878.8
 (SQL Overall)178691953.53250592.0
 
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.