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

61 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
boardlike164331(None) 
barnlike1437182b_arnlike
beadlike15137252bea_dlike
bearlike14156792bear_like
birdlike1535232b_irdlike
boatlike1457962boa_tlike
cordlike1537232co_rdlike
goadlike1435882goa_dlike
lardlike1336502_lardlike
lordlike1345812lo_rdlike
oarlike113411192_oar_like
toadlike1336142toa_dlike
armlike1348553__armlike
baglike14338943b_a_glike
balmlike1655353b_almlike
batlike133311883b_a_tlike
beaklike13155773bea_klike
beamlike16115843bea_mlike
beanlike14146843bea_nlike
bedlike14369533b__edlike
berrylike1842353berrylike
birdlife1443483b_irdlife
birdlime1343563b_irdlime
bladelike1643833bladelike
bloodlike1643863bloodlike
boardable1444893boardable
boarding123110233board_ing
boltlike1436313bo_ltlike
bowlike16349473bo__wlike
bowllike1734863bo_wllike
boxlike20267073bo__xlike
budlike14257873b__udlike
corklike1335993co_rklike
cormlike1646703co_rmlike
dwarflike2041613dwarflike
fadlike15318483_fa_dlike
foamlike1735143foa_mlike
forklike1435813fo_rklike
goatlike1346293goa_tlike
godlike1387563go__dlike
handlike1639153_handlike
hardline12310273_hardline
harelike1539613_harelike
herdlike1636113_herdlike
hoodlike1636563ho_odlike
hornlike1536503ho_rnlike
moatlike1446993moa_tlike
oaklike10268003_oa_klike
oatlike113412403_oa_tlike
parklike1337493_parklike
podlike14108553po__dlike
rodlike1288263ro__dlike
sandlike1339713_sandlike
sharklike1543933sharklike
soaplike1436903soa_plike
sparlike1437673spar_like
starlike1238813star_like
swordlike1742713swordlike
warlike142410473_war_like
wartlike1537043_wartlike
wormlike1735313wo_rmlike

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 Filter1786911486410.423422437.4
2DLD Change Limit148641618.76316962.3
3Display Results61610.0501220.0
 (SQL Overall)178691619.23619347.2
 
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.