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

80 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
strobils104656(None) 
strobil936961strobil_
strobila1044931strobila
strobile1047031strobile
strobiles1146951strobiles
strobili1044931strobili
strobilus1143611strobilus
strigils946852strigils
strobes93813262strob_es
strobic1138252strobi_c
strobilae1143482strobilae
strobilar1143022strobilar
strolls739182stro_lls
aerobics1246833aerobics
atropins10410493atropins
broils84114173_bro_ils
garboils1145663garboils
gerbils1037303ger_bils
parboils1237433parboils
probits112712573_probits
robins83617453__robins
roils54826793__ro_ils
scrolls938063scro_lls
searobins1145553searobins
serails73318363ser_ails
soils55327983s__o_ils
sorosis72611973sorosi_s
spoils84614533s_po_ils
stabile9312063st_abile
stabiles10311403st_abiles
stencils1046403stencils
steroids9911443stero_ids
sterols7313443stero__ls
stobs75718233st_ob__s
stogies8413693st_ogies
stoics8311113st_o_ics
stonily1049433st_onily
stoolies8311083stoolies
stools65117023st_o_ols
stories7324273st_ories
stormily1345243stormily
stotins73213873st_otins
strains74218153str_ains
straits74916323str_aits
streels73811343str_eels
strigil837263strigil_
strips85719653str__ips
strobe84513813strob__e
strokers123910903strokers
strokes114316323stro_kes
stroking132610943stroking
stroll6311603stro__ll
stromal93010593stromal_
strongly1245953strongly
strongyls1343153strongyls
strontias945603strontias
strophes13310603strophes
strops86220383stro__ps
strouds837803stro_uds
strowing122310563strowing
strows96718273stro__ws
stroyers11388923stroyers
stroying122410593stroying
stroys95914603stro__ys
strudels934123strudels
stubbily1564243stubbily
surveils1144523surveils
tobies84521023_t_obies
toils54527493_t_o_ils
trails64622513_tr_ails
tribals9610753_tribals
trochils1388583_trochils
troilus736413_tro_ilus
trois57226093_tro_i_s
trolls64613943_tro_lls
tropics113610653_tropics
tropins93116313_tropins
trotyls10236033_trotyls
trowels10358363_trowels
twibils1253113_twibils

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.403443402.0
2DLD Change Limit146162807.62619166.3
3Display Results80800.0302666.7
 (SQL Overall)178691808.05922172.9
 
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.