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

87 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
bobtail114655(None) 
bobtails1245191bobtails
bobtailed1443192bobtailed
foxtail1745382foxtail
hobnail1243972hobnail
obtain839182_obtain
oxtail1337652_oxtail
aortal65217513aorta_l
bail65042803__b_ail
bangtail1144353bangtail
bedrail1037253bedrail
bestial9311643bestial
bewail1189583b_ewail
boatable121610263boatable
boatbill1244463boatbill
boatel84314093boat_el
boatful1236283boatful
bobbin93410733bob_bin
bobcat12411253bobca_t
bobcats1335993bobcats
bobstay1443983bobsta_y
bobstays1543343bobstays
bobtailing1543513bobtailing
boil66335183bo___il
bonsai838463bonsai_
bootable12179223bootable
bootie85421163boot_ie
boral75831703bo_ra_l
boreal84817213borea_l
borstal939043borsta_l
bota66236503bo_ta__
botanic1159583bo_tanic
botany1139263bo_tany
botas75328783bo_ta_s
botel75121863bo_t_el
boxball18155323boxball
boxhaul1943013boxhaul
brail75525553__brail
brantail1046893brantail
broadtail1243123broadtail
brutal859383bruta_l
bubal94218213bub_a_l
bucktail1653913bucktail
cattail939183cattail
coattail1045313coattail
cocktail1645363cocktail
coital84117053coita_l
contain9315833contain
contrail10410983contrail
costal85419513costa_l
curtail9299663curtail
detail74516433_detail
dotal64919623do_ta_l
dovetail1244393dovetail
entail61114343_entail
fantail10310233fantail
foetal9311883foeta_l
fontal9313143fonta_l
foxtails1844583foxtails
hobnails1343303hobnails
horntail11105033horntail
mocktail1643673mocktail
mortal84616853morta_l
nostril749303nostril
notal55221353no_ta_l
obtains939163_obtains
octal71214723_octa_l
outsail71411413_outsail
oxtails1436383_oxtails
pigtail1046623pigtail
pintail9311183pintail
pontil8315463pont_il
ponytail1344553ponytail
portal84218463porta_l
postal84317533posta_l
potboil1195463potboil
rattail737803rattail
redtail858713redtail
reobtain1044623reobtain
retail65522073_retail
tail45443653___tail
toenail738783toenail
topsail976523topsail
total55321823to_ta_l
ventail10310453ventail
voltaic1245453voltaic
wagtail1145043wagtail

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 Filter1786911340270.406440125.6
2DLD Change Limit134027875.98322401.3
3Display Results87870.0302900.0
 (SQL Overall)178691876.41927837.8
 
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.