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

131 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
baases8521801(None) 
abases85720771abases
balases93815431balases
bases75644351b_ases
basses85428301basses
biases84618431biases
abase76023482abase_
abased96514992abased
abaser86414342abaser
abasers95311972abasers
abashes12510372abashes
abates85825032abates
abuses85119102abuses
apses76823912_apses
arses55733872_arses
asses55629282_asses
baaed85218162baa_ed
baals76122702baa_ls
baas66844672baa__s
babes95834112b_abes
babies106123642babies
baches135426942baches
badass949292badas_s
badasses1136172badasses
badges103917362badges
bagass938932bagas_s
bagasse1035142bagasse
bagasses1136312bagasses
baizes174315052baizes
bakes117035372b_akes
bales76250082b_ales
balsas86417522balsas
banes74945582b_anes
barbes104526232barbes
bardes95026932bardes
bares75457132b_ares
barges94528252barges
barres84427542barres
baryes116218502baryes
base64847022b_ase_
based85331582b_ased
baser74828922b_aser
basest84720492b_asest
bashes115631392bashes
basis75429862b_asis
basks115621762b_asks
bass66146782b_as_s
basset85225382basset
bassets96414822bassets
bassos85313702bassos
bastes85330382bastes
basts75936932b_asts
bates75846342b_ates
bathes116524832bathes
beasts84519722beasts
beses75830722b_eses
biased94012222biased
biasses94911652biasses
birses84717732birses
bises75435622b_ises
blades95221252blades
blames105121862blames
blares85021632blares
blase75524232blase_
blasts85116772blasts
blazes174817352blazes
boasts85017922boasts
bolases93315002bolases
bosses85925402bosses
bouses84931782bouses
bowses115718862bowses
braces108427772braces
braes75735052bra_es
braises93818872braises
brakes124923122brakes
brashes124518462brashes
brass75428022bras_s
brasses93818352brasses
braves115524082braves
brazes175522192brazes
brises84927612brises
broses86524402broses
burses84425512burses
buses75936012b_uses
busses85023382busses
camases114216342camases
carses85233652carses
cases75048382_cases
causes88026472causes
ceases84427072ceases
chases115128232chases
crases85532312crases
daises74318982daises
eases56041612_eases
erases64425402erases
eyases94513682eyases
feases95422922feases
gases65633992_gases
gasses75724782gasses
hanses95022632hanses
hawses125113992hawses
kvases13467102kvases
lapses85217692lapses
lases54944762_lases
lasses64827592lasses
leases65428112leases
lyases95211872lyases
manses84225512manses
marses84827112marses
masses85028712masses
myases113711552myases
oases55330982_oases
parses85534702parses
pases75346502_pases
passes86030472passes
pauses84621472pauses
peases85229472peases
phases114618402phases
prases84429022prases
raises64826542raises
rases55447212_rases
sasses64124392sasses
stases64225562stases
tasses64826762tasses
tawses94913192tawses
teases65426272teases
ukases10358062ukases
upases84112902upases
urases63723562urases
valses94514612valses
vases84626262_vases

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 Filter178691825510.220812231.8
2DLD Change Limit825511316.03013690.0
3Display Results1311310.143916.1
 (SQL Overall)1786911316.39327951.0
 
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.