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

79 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
rapiers9501287(None) 
rapers84327181rap_ers
rapier84019991rapier_
rappers113618441rappers
apers76629132_ap_ers
brasiers103710512brasiers
braziers19397192braziers
cahiers123510672cahiers
capers105428142cap_ers
cappers134419402cappers
copiers114215962copiers
crappers144011022crappers
drapers105313352drap_ers
gapers94520472gap_ers
grapier103712602grapier_
graziers18387122graziers
japers154616172jap_ers
lappers113717462lappers
lapsers93911052lapsers
mappers133313782mappers
nappers114214862nappers
paniers94717332paniers
papers105125322pap_ers
piers75926332__piers
rabies85226022rabie_s
racers84725432ra_cers
racier85120972racier_
rackers134320452rackers
rafters103715632rafters
raiders84615142raiders
railers74420662railers
raisers73617392raisers
rakers104123572ra_kers
ralliers84010832ralliers
ramies84630462ramie_s
rammers113715042rammers
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
raper74932752rap_er_
rapes75740722rap_e_s
raphes115117452raphe_s
rapider1067902rapider_
rapids94913892rapi_ds
rapiered1136052rapiered
rapines95120862rapines
rapists92510752rapists
rappees113611452rappees
rappels11448802rappels
rapper104621572rapper_
raptors94213352raptors
rasers64526782ra_sers
rashers104020912rashers
raspers94415922raspers
raspier93110642raspier_
rasters74629022rasters
raters63936582ra_ters
ratters74422472ratters
ravers94628182ra_vers
razers154919612ra_zers
reapers93520452reap_ers
reliers75519212reliers
repiners103913432repiners
repliers103710162repliers
ribiers9319752ribiers
rippers114115032rippers
ropers84325902rop_ers
ropier84118802ropier_
sapiens9310172sapiens
sappers113518902sappers
spiers84421742_spiers
tapers84025812tap_ers
tapirs84113172tapi_rs
tappers113416542tappers
trappers123711042trappers
variers103712662variers
wrappers15306932wrappers
yappers144012252yappers
zappers203911632zappers

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.356501941.0
2DLD Change Limit107671792.98636058.6
3Display Results79790.0302633.3
 (SQL Overall)178691793.37252992.6
 
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.