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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
trapezes193654(None) 
trapeses1039151trapeses
trapeze1836251trapeze_
trapes85024462trap__es
trapesed1136472trapesed
trapezia1944332trapezia
trapezii1943082trapezii
trapezist2044342trapezist
trapezius2043342trapezius
apexes1539133__apexes
arabizes1969103arabizes
braizes183112453bra_izes
brazes175522193bra__zes
breezes18318693br_eezes
capizes20410373_capizes
crapes104727693crap__es
crappies142911153crappies
crazes174720133cra__zes
dragees9359483drage_es
draperies1249193draperies
drapers105313353drape_rs
drapes95419653drap__es
drawees11378363drawe_es
frappes14328383frap_pes
freezes193310353fr_eezes
friezes19418913fr_iezes
graperies1239613graperies
grapes95123123grap__es
graphemes1743633graphemes
grapples13348123grapples
grazes164519643gra__zes
prezes173614693pr__ezes
propenes122816513propenes
racemes1139093_racemes
ragees74618663_rage_es
rakees104516973_rake_es
ramees84620893_rame_es
ranees64623963_rane_es
rapers84327183_rape_rs
rapes75740723_rap__es
raphes115117453_rap_hes
rapines95120863_rapines
rappees113611453_rappees
razees154314763_raze_es
razes145032703_ra__zes
razzes144910073_ra_zzes
rupees8312573_rupe_es
stapedes11197753stapedes
tapeless10218643t_apeless
tapered102612933t_apered
taperer92511793t_aperer
taperers10269773t_aperers
tapers84025813t_ape_rs
tapes75838603t_ap__es
tapises92914013t_apises
taxemes1635853t_axemes
teepees939263teepe_es
tepees84215243t_epe_es
terpenes102111573terpenes
topazes1857313t_opazes
topees85519703t_ope_es
toupees938513toupe_es
traceless11228643traceless
traceries11312863traceries
tracers94917843trace_rs
traces85329933tra__ces
trachles13311753trachles
traders84316953trade_rs
trades75724503tra__des
traduces1136563traduces
tragedies1146523tragedies
trainees82712063trainees
traipses1036873traipses
trajects1744533trajects
trameled11309073trameled
tramells10327833tramells
tramels93812493trame_ls
trampers123210393trampe_rs
tramples122610203tramples
trances93919643tra_nces
tranches132915513tranches
trannies8415013trannies
trapans92812463trap_ans
trapezial2043943trapezial
trapezists2152923trapezists
trapezium2253443trapezium
trapeziums2352353trapeziums
trapeziuses2251603trapeziuses
trapezoid2153313trapezoid
trapezoids2252743trapezoids
traplines11310373traplines
trapnest10310923trap_nest
trapnests1144433trapnests
trapped124512213trap_ped
trapper113912803trap_per
trappers123711043trappers
trappose1245813trappose
trappous1246023trappous
traps75727483trap___s
trashes104119263tra_shes
trasses74819323tra_sses
traveled12349453traveled
traveler11328433traveler
travelers12266773travelers
travels104711293trave_ls
traverse1136213traverse
traverses1246343traverses
traves94222743tra__ves
trees55835763tr__e_es
trienes74118413tr_ienes
tripes85324873trip__es
triples94616873trip_les
triplexes1844253triplexes
triposes1039973triposes
triremes1035523triremes
trisemes1036643trisemes
tropes84824353trop__es
trophies13413673trophies
tropines102214923tropines
tweezes19345703t_weezes

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 Filter1786911461620.530337152.8
2DLD Change Limit1461621207.39019778.3
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.96622431.7
 
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.