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

76 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
tollbar94545(None) 
tollbars1045441tollbars
toolbar944771toolbar
collar83816172coll_ar
dollar74110982doll_ar
tolar55524112to_l_ar
toller63819442toll_er
tollman935862tollman
tollway1344792tollway
toolbars1044742toolbars
allobar946663allobar
bolar75123473bo_l_ar
bolivar1244853bolivar
bollard103210503boll_ard
bulbar1039583_bulbar
bullbat1158553bullbat
cellar84514983cell_ar
collard103712923coll_ard
collars93816573coll_ars
collier93618153collier
dollars83311023doll_ars
foliar93210973fo_liar
holla84918493holl_a_
hollas94616903holl_as
holler93520613holl_er
holloa94914823holloa_
holloas103814943holloas
jollier142911003jollier
kilobar1344613kilobar
lobar7313013__lobar
loller63315283loll_er
millibar1275353millibar
molar75223093mo_l_ar
mollah11319453moll_ah
olla44821173_oll_a_
ollas54218283_oll_as
pillar8314023pill_ar
polar75623453po_l_ar
pollard103511143poll_ard
poller83921853poll_er
poplar103611113popl_ar
rollback1644883rollback
roller63919793roll_er
rollway1344653rollway
solar55927343so_l_ar
solunar735283solunar
stellar72610423stell_ar
talar56225383t_al_ar
tallboy1265143tallboy
taller63721963tall_er
tallier72817213tallier
taskbar1393023taskbar
teller63519813tell_er
tiller64222543till_er
toiler63918283toil_er
tola45236333to_l_a_
tolan55124013to_l_an
tolars64817943to_l_ars
tolas54532773to_l_as
toll45535263toll___
tollage82610163tollage
tolled73819033toll_ed
tollers73217463tollers
tollgate946253tollgate
tolling83418563tolling
tollmen935733tollmen
tolls54728433toll__s
tollways1444133tollways
tombac12258883to_mbac
tombak14237753to_mbak
tombal102311023to_mbal
toolbox1653633toolbox
tooler63818613tool_er
troller73913173troll_er
typebar1442993typebar
volar86917413vo_l_ar

Search took 8 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.470380193.6
2DLD Change Limit134027766.93619323.4
3Display Results76760.0302533.3
 (SQL Overall)178691767.43624030.5
 
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.