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

92 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
garboils114566(None) 
garboil1036511garboil_
parboils1237431parboils
gambols1238592gambo_ls
gerbils1037302gerb_ils
gumboils1343892gumboils
parboil1138322parboil_
aboil72217543_a_boil_
airfoils1144003airfoils
arbores94016033_arbores
arbors84717873_arbo_rs
arbours93910033_arbours
archils12510533_archils
argils75213623_ar_gils
argols74514613_argo_ls
arils58732203_ar__ils
aroids75118223_ar_oids
assoils776663_assoils
babools11319453ba_bools
barbells12368823barbells
barbels114514433barb_els
barbies114519593barb_ies
boils75427193___boils
broils84114173_br_oils
carbolic1448323carbolic
carbolics1546723carbolics
carbons115418943carbo_ns
carbonyls1675033carbonyls
carboras12311573carboras
carbos105122263carbo__s
carboxyls2363693carboxyls
carboys144711783carbo_ys
carols85124983car_o_ls
carpools1237883carpools
charbroils1742363charbroils
corbeils12358073corbeils
darbies104216983darb_ies
embroils1245773embroils
gabies93820733ga_b_ies
gabions102410053ga_bions
gaboons10289893ga_boons
gadoids1036863ga_doids
gambias125010733gamb_ias
gambirs12359083gamb_irs
gambits12399723gamb_its
gamboges1435653gamboges
gambol1138223gambo_l_
gambrels1334213gambrels
ganoids939323ga_noids
gaols66717573ga__o_ls
garbages1238183garbages
garbing113613273garb_ing
garble94118453garb__le
garblers113810283garblers
garbles104016923garb_les
garbless11388253garbless
garbling12249453garbling
garboard1247243garboard
garboards1346363garboards
garbs86321413garb___s
garcons102411643garco_ns
gargoyle1342503gargoyle
gargoyles1442833gargoyles
garlics1038013gar_lics
garotes8614563gar_otes
garrons82713463garro_ns
garrotes969363garrotes
gearboxes1942933gearboxes
gerbil938343gerb_il_
globoids1244413globoids
grails77518783g_r_ails
groins73917203g_r_oins
growls104711113g_r_owls
gumboil1244373gumboil_
gumbotils1451743gumbotils
harbors12412413harbo_rs
harbours1346903harbours
labroids1155833labroids
overboils1436623overboils
panbroils1343223panbroils
parafoils1445503parafoils
parboiled1445223parboiled
parols84722613par_o_ls
potboils1284633potboils
preboils1267293preboils
reboils94111723_reboils
reoils64516873__reoils
roils54826793__r_oils
sarcoids1137803sarcoids
strobils1046563strobils
turmoils1043983turmoils
upboils1184703_upboils

Search took 9 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 Limit146162928.03318195.2
3Display Results92920.0462000.0
 (SQL Overall)178691928.23521699.0
 
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.