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

252 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
brewises133721(None) 
betises94816122b_etises
braises93818872br_aises
brewages1436382brewages
brewings14296692brewings
brewis11469982brewi__s
brises84927612br__ises
browses124712692brow_ses
bruises93212912br_uises
lewises1039132_lewises
precises123218332precises
premises123018272premises
previses133814282previses
prewires133811012prewires
remises93423482_remises
rerises73525882_rerises
revises104220532_revises
rewires104717112_rewires
aegises8311373_aegises
alewives1444283alewives
arenites8917103arenites
arises65233803ar__ises
arrises71617583ar_rises
baptises1238923baptises
barbwires1643643barbwires
beedies10314203beedi_es
beehives1644483beehives
beelines103312803beelines
beiges91014413b_e_iges
bekiss1236373b_ekis_s
bekisses1434243b_ekisses
belies84631053b_eli_es
bemires113212833b_emires
bemists113410703b_emists
bemixes18338653b_emixes
bemuses1139293b_emuses
berberises1444903berberises
berimes115216643b_erimes
berlines102315453berlines
berries94423553berri_es
beses75830723b_e__ses
besides104814533b_esides
betides104915263b_etides
betimes115114413b_etimes
betise85616273b_etise_
bevies114017303b_evi_es
bewares12313373b_ewares
bewigs1246533b_ewi_gs
bises75435623b___ises
blemishes1665083blemishes
blesses93812393ble_sses
boreases10310253bore_ases
bowses115718863b_ow_ses
braise84318753br_aise_
braised104014803br_aised
braizes183112453br_aizes
brasses93818353br_asses
brassies103613533brassies
braxies16711463braxi_es
breaches153714123breaches
breasts939703bre_asts
breathes134212903breathes
bredes94818473bre__des
breeches15258673breeches
brees75632553bre___es
breezes18318693bre_ezes
breves115516423bre__ves
brevier1237763brevi_er
breviers1335923breviers
brevities1446423brevities
brewage1347183brewage_
brewed125411873brew__ed
brewer114812553brew__er
breweries1447583breweries
brewers123811063brew_ers
brewing133411153brewi_ng
brewpubs174873brewpubs
brews105617073brew___s
brewski16101923brew_ski
brewskies18132273brewskies
brewskis17111893brewskis
bribes105918533br__ibes
brides94423513br__ides
bries74942153br__i_es
brines85028853br__ines
brinies93317913brini_es
brisks124611403br__isks
briss75824273br__is_s
brisses94314313br_isses
bromides13219363bromides
bromines122514253bromines
bromisms1436403bromisms
bromizes21258333bromizes
broses86524403br__oses
browless1346653browless
brownies13189613brownies
browse115713853brow_se_
browsed134511233brow_sed
browser124911143brow_ser
browsers13449203brow_sers
brucines1237763brucines
bruise83412873br_uise_
bruised10389503br_uised
bruiser9349573br_uiser
bruisers10307953br_uisers
brutisms1245413brutisms
bruxisms1942943bruxisms
cercises12410933cercises
cerises94722253_cerises
chemises153211983chemises
clevises1336903clevises
creases94020963cre_ases
creeses93914623cre_eses
creolises1157893creolises
cresses94219813cre_sses
crevices1536713crevices
crewless1335413crewless
crises84529433cr__ises
cruises93514443cr_uises
demises103719563_demises
dermises112512023dermises
derrises93012783derrises
devises114116763_devises
dresses83716173dre_sses
drowses114610233drow_ses
ecesises1037023ecesises
egises7312493__egises
elegises9128823elegises
eremites10312603eremites
erewhiles1563173erewhiles
fraises104215693fr_aises
frises94124273fr__ises
greases84816713gre_ases
grecizes2035683grecizes
greiges937733gre_iges
greisen856503gre_isen
greisens954653gre_isens
irises64221173ir__ises
iritises839973iritises
itemises1087693itemises
kermises14248313kermises
krewes1337923krew__es
krises105016083kr__ises
merises93421423_merises
newies91014073_newi_es
newsies101310383_newsies
noesises838503noesises
obelises1039103obelises
orchises1338773orchises
oreides8312023ore_ides
orrises71312233or_rises
peises84125043_pe_ises
penises9318193_penises
poetises10313953poetises
praises94121103pr_aises
praxises1739063praxises
precipes143212213precipes
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prelives13310383prelives
premies113823063premi_es
premise113818553premise_
premised133013193premised
premiss113513813premis_s
premisses13288763premisses
premixes193110083premixes
prerinses1138813prerinses
presides11414913presides
presses93523153pre_sses
previse123713793previse_
prevised143611073prevised
prewashes1744753prewashes
prewire124311143prewire_
prewired14358473prewired
prexies163415003prexi_es
prises84133173pr__ises
promises122916763promises
raises64826543_r_aises
realises82420183_realises
rebuses94915293_rebuses
recipes113314463_recipes
recites93524583_recites
recuses94619463_recuses
refiles104122423_refiles
refines105426343_refines
refires104820313_refires
refixes174813173_refixes
refuses104918553_refuses
regimes104514743_regimes
regives115014213_regives
rehires105016113_rehires
reives95723043_re_ives
relies65036423_reli_es
relines75331323_relines
relishes11311953_relishes
relists73817053_relists
relives104619443_relives
remiges103015473_remiges
remise84221953_remise_
remised103516843_remised
remiss84216353_remis_s
remixes164313873_remixes
repines94927383_repines
reposes94021263_reposes
reprises102615463_reprises
reraises8415643_reraises
rerise64325633_rerise_
rerisen73613643_rerisen
resides84523283_resides
resiles74026543_resiles
resists74414923_resists
resites74027793_resites
resizes164216843_resizes
reties65436193_reti_es
retiles74426993_retiles
retimes95020173_retimes
retines75134673_retines
retires74726213_retires
retwists1135603_retwists
reuses66025523_re_uses
reviles104421353_reviles
revise94019743_revise_
revised113815483_revised
reviser104114663_reviser
revisers113511933_revisers
revives134715543_revives
rewakes144614983_rewakes
rewashes1447033_rewashes
rewaxes173911333_rewaxes
rewiden1137533_rewiden
rewidens1235533_rewidens
rewinds114810483_rewinds
rewins95020823_rewi_ns
rewire95421413_rewire_
rewired115413283_rewired
rewrites11311063_rewrites
rexines144719153_rexines
rises55244043_r__ises
seises64026713_se_ises
semises93916553_semises
speises93813933spe_ises
treatises9310373treatises
trellises947023trellises
tresses73719543tre_sses
ureases74416723ure_ases
ureides8311103ure_ides
wises85633193___wises

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.423422437.4
2DLD Change Limit1461622526.48322545.4
3Display Results2522520.0932709.7
 (SQL Overall)1786912526.99925530.9
 
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.