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

91 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
upraisers1117442(None) 
praisers103410831_praisers
upraiser10175841upraiser_
upraises10188471upraise_s
uprisers10206771upr_isers
appraisers1443502appraisers
praiser93413942_praiser_
praises94121102_praise_s
raisers73617392__raisers
upbraiders1542362upbraiders
upraise9158602upraise__
upraised11167412upraise_d
upriser9218762upr_iser_
uprises92012732upr_ise_s
uprivers13215562upr_ivers
appraisees1443153appraisees
appraiser1344953appraiser_
appraises1347423appraise_s
apprisers1345053apprisers
braiders114110573_braiders
braises93818873_braise_s
brasiers103710513_brasiers
bruisers10307953_bruisers
cruisers10438273_cruisers
dispraisers1443423dispraisers
drainers92811253_drainers
erasers74413943_era_sers
fraises104215693_fraise_s
grainers93012073_grainers
harassers1246193harassers
kaisers11369273__kaisers
mortisers1186163mortisers
outraises9311023outraise_s
parises94827183_parise_s
parsers94118153_p_arsers
passers94717753_p_assers
pausers94113223_p_ausers
pavisers13387443_pavisers
plaisters1137813_plaisters
plaiters103512633_plaiters
poisers94214433_p_oisers
praise84419413_praise__
praised104214813_praise_d
prancers123210333_prancers
prases84429023_pra_se_s
praters94921653_pra_ters
prawners1346003_prawners
praxises1739063_praxise_s
prayers124212853_pra_yers
pressers103215023_pressers
pricers113915063_pr_icers
priers84521193_pr_i_ers
primers114215673_pr_imers
prisere9310943_pr_isere
priseres10310823_pr_iseres
prises84133173_pr_ise_s
prizers183911843_pr_izers
promisers13268203_promisers
prosers94219643_pr_osers
pursers93916093pur__sers
raiders84615143__raiders
railers74420663__railers
raiser66620103__raiser_
raises64826543__raise_s
rasers64526783__ra_sers
reraises8415643reraise_s
risers64624783__r_isers
sprawlers1433893sprawlers
sprayers13367053spra_yers
strainers9510383strainers
surmisers1145203surmisers
surpassers1243083surpassers
surprisers1243633surprisers
trailers82912923_trailers
trainers83114643_trainers
unhairers12183273unhairers
unraised91811883unraise_d
upases84112903up_a_se_s
upbraider1442573upbraider_
updaters11255183upda_ters
upgathers1582533upgathers
uplanders1234853uplanders
upraising1237263upraising
uprates93814863upra_te_s
uprise82313693upr_ise__
uprisen9227353upr_ise_n
upriver12196933upr_iver_
uprooters1164253uprooters
uprouses1037553uprouse_s
urases63723563u_ra_se_s
utilisers953553utilisers

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641917.25020502.2
3Display Results91910.0303033.3
 (SQL Overall)178691917.43624030.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.