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

105 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
zebrass183411(None) 
zebras1737851zebra_s
brass75428022__brass
zebra1637882zebra__
zebraic2044292zebraic
zebrano1843852zebrano
zebranos1943712zebranos
zebrasses2043512zebrasses
bass66146783__b_ass
betrays12127823betrays
bewraps14135403bewraps
bewrays15145113bewrays
brads85528293__brads
braes75735053__braes
brags85625103__brags
brans75437433__brans
bras65746453__bra_s
brash106221563__brash
brassy11509233__brassy
brats75336013__brats
braws106425193__braws
brays106723113__brays
briss75824273__briss
cobras104014193cobra_s
crass76328043__crass
cuirass934973cuirass
debags104211063deb_ags
debarks14388493debarks
debars94218043deb_ars
debase94014473deb_ase
debases103814133deb_ases
debeaks1436103debeaks
debris93311493debr_is
declass1038733declass
defrags1236193defrags
defrays1436113defrays
depress10239873depress
derats74625063de_rats
derays105514253de_rays
dobras94811913dobra_s
eelgrass942973eelgrass
egress73310433_egress
eras45441503_e_ra_s
erase54925493_e_rase
erases64425403_e_rases
eyass84410783_e_yass
eyras84715923_eyra_s
ferals94216643fe_rals
ferbams1435743ferbams
frass85321123__frass
gerahs1039413ge_rahs
grass66125203__grass
harass9313943_harass
heiress1036813heiress
herbals122710603herbals
kebabs14418513keb_abs
kebars124112493keb_ars
keblahs1634563keblahs
libras83711703libra_s
matrass939403matrass
megass9219443me_gass
morass84614493_morass
peeress939503peeress
rebars84019833reb_ars
recross989833recross
redraws11218473redraws
redress82511873redress
regress82711453regress
repass84114703re_pass
repress92712683repress
rewraps12136563rewraps
ribgrass1143423ribgrass
ryegrass1242793ryegrass
sabras85116363sabra_s
seeress7311573seeress
seracs84418573se_racs
serais64326133se_rais
strass67117223_strass
subbass1138033subbass
terais64023513te_rais
terras63516973terra_s
terrases82111483terrases
tetrads82910193tetrads
tetras63017623tetra_s
trass56226473__trass
umbras1038643umbra_s
verbals121910743verbals
webcams1643073webcams
webcast1445553webcast
webcasts1543313webcasts
webless1237003webless
yerbas11119293yerba_s
zeals145320853ze__als
zebecks24274193zebecks
zebecs19316183zeb_ecs
zebrafish2651783zebrafish
zebrine1836463zebrine
zebrines1935883zebrines
zebroid1936463zebroid
zebus164610053zeb__us
zerks185113823ze_r_ks
zeroes154314343ze_roes
zeros144918113ze_r_os
zetas145018163ze_ta_s
zirams17438643z_irams

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271056.50020619.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.67026790.3
 
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.