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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
brassish134643(None) 
bassist9312742b_assist
brackish1987612brackish
brainish1338812brainish
brandish1469022brandish
brasses93818352brasses_
brassica1244872brassica
brassie93411522brassi_e
brassier103310532brassier
brassies103613532brassies
brassiest11369712brassiest
brassily1336622brassily
brassing112612302brassing
brattish1346972brattish
raspish1298102_raspish
aspish114810333__aspish
assist6314603__assist
babyish1736513b_abyish
bakshish2043743bakshish
baldish1339503b_aldish
banish111416043b_a_nish
basis75429863b_a_sis_
basses85428303b_asses_
bassi77019323b_assi__
bassists1037183b_assists
bassos85313703b_assos_
batfish1558683b_atfish
beamish14259293bea_mish
bearish123013273bea_rish
beauish12268513bea_uish
biasses94911653biasses_
biassing11307263biassing
blackish1976713blackish
blandish1497003blandish
boarfish1635753boarfish
boarish123911913boa_rish
bossism1136063b_ossism
braise84318753bra__ise
braises93818873braises_
braising113014563braising
brash106221563bra___sh
brashes124518463brashes_
brashest133511763brashest
brashier13389933brashier
brashiest14359853brashiest
brasier94516753bra_sier
brasil8713863bra_si_l
brasils9410973bra_sils
brass75428023bra_s_s_
brassage1145283brassage
brassard1144683brassard
brassart1047503brassart
brassed103612373brass_ed
brassicas1344053brassicas
brassiere11365383brassiere
brassiness1235483brassiness
brassy11509233bra_s_sy
brinish1239963br_inish
brisses94314313brisses_
broadish1446933broadish
broguish1444103broguish
brownish1645643brownish
brutish1237703br_utish
cassis84818853_cassis_
chassis123910663chassis_
classis93712723classis_
classism12407173classism
classist104010383classist
coassist10298803coassist
crankish1736513crankish
crasis85020473cra_sis_
crassest103411523crassest
crawfish1944233crawfish
crayfish1944253crayfish
draffish1844553draffish
frasses104314513frasses_
grasses84117343grasses_
grassier9349283grassier
grassiest10309513grassiest
grassily1236433grassily
grassing103311973grassing
grayfish1844483grayfish
grayish1437813gra_yish
hashish1238353_hashish
lassis65216703_lassis_
orangish1246543orangish
prankish1737023prankish
radish103516913_ra_dish
raffish1658843_raffish
rakish134313963_ra_kish
rammish1437563_rammish
rankish14510383_rankish
ratfish1338773_ratfish
rattish10510823_rattish
ravish123414033_ra_vish
rawish123012913_ra_wish
trampish1535653trampish
trasses74819323trasses_
waspish1586923_waspish
wrasses103812593wrasses_

Search took 10 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.1561145455.1
2DLD Change Limit1461621008.96616301.8
3Display Results1001000.0502000.0
 (SQL Overall)1786911009.17219482.2
 
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.