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

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

126 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
brutes8611868(None) 
brumes106417071brumes
brute75321781brute_
bruted95113261bruted
bruts75922951brut_s
bruxes154811021bruxes
butes714535871b_utes
acutes83917722acutes
arbutes939702arbutes
aretes64425352aretes
barites94322332barites
barytes124611152barytes
bastes85330382bastes
bates75846342b_ates
berates94126852berates
bhuts105812952bhut_s
bites75641172b_ites
blites84721212blites
blues75127042blu_es
bluets87215492bluets
blumes105917792blumes
boites84322702boites
borates94823012borates
boules84925972boules
bouses84931782bouses
bouts75131312bout_s
braces108427772braces
braes75735052br_aes
brakes124923122brakes
brats75336012brat_s
braves115524082braves
brazes175522192brazes
bredes94818472bredes
brees75632552br_ees
breves115516422breves
bribes105918532bribes
brides94423512brides
bries74942152br_ies
brines85028852brines
brises84927612brises
briths115113862briths
brits76433082brit_s
britts84813442britts
bromes104719762bromes
broses86524402broses
broths115013922broths
brughs12509062brughs
bruins86014952bruins
bruise83412872bruise
bruises93212912bruises
bruited104110352bruited
bruiter93710632bruiter
bruiters10329132bruiters
bruits85714452bruits
brume95817982brume_
brunet84419292brunet
brunets9419552brunets
brunts85215452brunts
brushes124014662brushes
brut66537962brut__
brutal859382brutal
brutely1235932brutely
brutish1237702brutish
brutism1146772brutism
bruxed16466982bruxed
burets84321262burets
buries84633272buries
burkes124421312burkes
burses84425512burses
buses75936012b_uses
bute66739672b_ute_
buteo75419892b_uteo
buteos84913412b_uteos
butles84423912b_utles
buts67247692b_ut_s
buttes84822562buttes
butts75824252b_utts
bytes105217492b_ytes
chutes114615762chutes
crates85736052crates
croutes94815642croutes
cruces105117542cruces
crudes96218622crudes
cruets85314952cruets
cruses88127712cruses
cruxes154911562cruxes
cutes79438312_cutes
drupes94912652drupes
druses75517252druses
elutes64020312elutes
embrutes1245182embrutes
flutes95421782flutes
frites94922482frites
glutes74517672glutes
grates75429882grates
grues65721962gru_es
grumes94415552grumes
imbrutes1244202imbrutes
jutes125125132_jutes
lutes55836662_lutes
mutes75033782_mutes
orates64328612orates
prates84633162prates
prudes94215442prudes
prunes83419062prunes
rates55352012_rates
rites54442552_rites
rotes56143902_rotes
routes66129312routes
rubes74928412_rubes
rues46044482_ru_es
rules55234252_rules
runes55530222_runes
ruses56136582_ruses
ruths85714642_ruths
ruts44541492_rut_s
sautes63924912sautes
scutes85219192scutes
shutes93518212shutes
truces84916332truces
trues54925322tru_es
truths9449502truths
urates65027762urates
uruses63616502uruses
utes45930882__utes
writes94420332writes

Search took 5 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 Filter178691825510.220812231.8
2DLD Change Limit825511263.81021666.9
3Display Results1261260.0333818.2
 (SQL Overall)1786911264.06343980.1
 
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.