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

145 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
blames10512186(None) 
blades95221251blades
blame95625491blame_
blamed116017951blamed
blamer104417141blamer
blamers115314211blamers
blams95023851blam_s
blares85021631blares
blazes174817351blazes
blumes105917791blumes
flames114723691flames
lames75445541_lames
ablates92416902ablates
alamos8415002alamos
alates64833962alates
almes75126542al_mes
arames84622572arames
baases85218012baases
babes95834112b_abes
bakes117035372b_akes
balases93815432balases
bales76250082b_ales
balms95723922balm_s
bams87044452b_am_s
banes74945582b_anes
bares75457132b_ares
bases75644352b_ases
bates75846342b_ates
beamed115720732beamed
beams95328172beam_s
beldames1336802beldames
benames112814602benames
bermes106023002bermes
biases84618432biases
biomes103815252biomes
blabs95619632bla_bs
blacks144914952blacks
blade85923332blade_
bladed104717762bladed
blader93618582blader
bladers104214682bladers
blae66134642bla_e_
blaffs14426622blaffs
blahs105616512bla_hs
blains84516372blains
blam86131702blam__
blanks124112892blanks
blare75826232blare_
blared95018242blared
blase75524232blase_
blasts85116772blasts
blate75933782blate_
blats75132502bla_ts
blawed124713892blawed
blaws105620462bla_ws
blaze165520832blaze_
blazed184314712blazed
blazer174414022blazer
blazers184811682blazers
blimey13468452blimey
blimps12588152blimps
blites84721212blites
blokes123813882blokes
blues75127042bl_ues
blume95619892blume_
blumed114313642blumed
blypes13357542blypes
bolases93315002bolases
braces108427772braces
braes75735052bra_es
brakes124923122brakes
braves115524082braves
brazes175522192brazes
bromes104719762bromes
brumes106417072brumes
bynames14256242bynames
cames97047312_cames
clades94920462clades
clamps124515082clamps
clams95127672clam_s
claves115020062claves
climes104720002climes
dames85435852_dames
elates65032362elates
fames105735922_fames
flakes134118872flakes
flambes14419502flambes
flame105124442flame_
flamed124618972flamed
flamen115215992flamen
flamens124611062flamens
flamer114919122flamer
flamers124616362flamers
flams105125012flam_s
flanes94522422flanes
flares94521702flares
flaxes165015352flaxes
flumes115119732flumes
frames115119862frames
games86238552_games
glaces94218022glaces
glades84820342glades
glams85822932glam_s
glares75518862glares
glazes165315642glazes
glimes94717522glimes
glumes94516812glumes
hames106138702_hames
kames115024692_kames
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lamas75532792_lamas
lambs95921412_lambs
lame66849292_lame_
lamed85235292_lamed
lameds94812032_lameds
lamer75233702_lamer
lamest84722762_lamest
lamps95624832_lamps
lams66552262_lam_s
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
laves86039152_laves
laxes125430092_laxes
lazes145129572_lazes
limes75636502_limes
llamas888972llamas
names74833362_names
oblates91913242oblates
places104323702places
plages94520152plages
planes85028082planes
plates85432242plates
plumes104318132plumes
shames114726222shames
slakes104021882slakes
slams74927902slam_s
slates64934062slates
slaves95023022slaves
slimes84722042slimes
tames75242012_tames
ulamas8910452ulamas
wames106432802_wames

Search took 4 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.203880251.2
2DLD Change Limit825511452.86028864.0
3Display Results1451450.0463152.2
 (SQL Overall)1786911453.10957475.4
 
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.