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

106 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
behalves164408(None) 
behaves15198521beha_ves
behave14209012beha_ve_
behaved16176682beha_ved
behaver15206722beha_ver
behavers16205612beha_vers
behooves1653792behooves
behoves15177352beh_oves
bivalves1643382bivalves
halves124717092__halves
bales76250083b__al_es
basaltes10367683basaltes
beaches144120653be_aches
beadles103414733be_adles
beagles103212123be_agles
beanies93821093be_anies
beaver114819253be_a_ver
beavers124417323be_a_vers
becalmed1534813becalmed
becalms1335743becal_ms
bechalked2143593bechalked
bechalks1944793bechal_ks
bechances1847613bechances
beefaloes1443233beefaloes
beehives1644483beehives
beetles9312083beetl_es
beeves114615043be__eves
befallen1344033befallen
befalls12349123befal_ls
begalled1236023begalled
begalls10319163begal_ls
begazes1937963bega_zes
behalf14310953behal__f
beholden1443593beholden
beholder1435053beholder
beholders1544933beholders
beholds1336423behol_ds
behoove1553773behoove_
behooved1743133behooved
behove14207203beh_ove_
behoved16205563beh_oved
beladies11310423beladies
belies84631053be__lies
believes13449403believes
belles85325993be__lles
bellies94023723be_llies
benames112814603bena_mes
berakes134815773bera_kes
berates94126873bera_tes
bereaves1338273bereaves
beshames1537203besha_mes
beslaved1435023beslaved
betaines10313293betaines
betakes134212523beta_kes
bewares12313373bewa_res
bezazzes1741983bezazzes
bialies93618413b_ialies
bivalve1543593bivalve_
bivalved1742683bivalved
braves115524083b_ra_ves
bubales113513343bubal_es
calves115119283__calves
deaves105319533de_a_ves
delves104917083de__lves
devalues1235853devalues
devolves15286263devolves
eaves85231993_e_a_ves
elves85118743_e__lves
enhaloes1197343enhaloes
evolves13286743_evolves
exhales1737143exhal_es
females12310663femal_es
hales85449843__hal_es
haloes94623863__haloes
halvas124714173__halvas
halve114818923__halve_
halved134813903__halved
halvers133311423__halvers
haves116034873__ha_ves
heaves124120303he_a_ves
helves124316063__helves
inhales10511863inhal_es
leaves94222383le_a_ves
mealies92821933me_alies
pelves114514663pe__lves
reales64934123re_al_es
reaves94127573re_a_ves
regales83520793regal_es
rehashes1436953rehashes
repaves123513653repa_ves
resales74724903resal_es
reshaves1438733resha_ves
resolves113010783resolves
revalues1137883revalues
revolves14278623revolves
salves94221763__salves
selves94119613se__lves
shales94731253_shal_es
shaves125224933_sha_ves
sheaves134412973shea_ves
shelves134112093_shelves
unhalved1556513unhalved
valves124113783__valves
weaves123616373we_a_ves
whales124716943_whal_es
wharves16457133_wharves

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621066.73621698.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.93825755.4
 
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.