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

78 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
turbinal104562(None) 
turbinals1144251turbinals
terminal1039722terminal
trinal6516952t_r_inal
turbinate1146672turbinate
turbine9310302turbin_e
turbines1039902turbines
turrical1046202turrical
urinal6614122_ur_inal
albinal937813_albinal
barbital1247053barbital
binal75323823___binal
burial84117623bur_i_al
carbinol1245773carbinol
cardinal1139553cardinal
carinal94318223car_inal
corbina111911443corbina_
corbinas12229383corbinas
cubical1338463cu_bical
cubital1137103cu_bital
curbing123814023curbin_g
curbings13407313curbings
curial84019153cur_i_al
forbidal1444823forbidal
germinal1147253germinal
lubrical12116093lubrical
luminal93711003lu_minal
marginal1137603marginal
morainal1047193morainal
orbital936923_orbital
ordinal838633_ordinal
rhinal9510183__rhinal
rubrical1296093rubrical
ruminal9289993ru_minal
surgical1146253surgical
survival1443923survival
tarnal63716503tar__nal
tegminal1144453tegminal
terbia8311153terbi_a_
terbias9310743terbi_as
terminals1147453terminals
terpinol1044073terpinol
tertial7313853terti_al
tibial849843t_ibi_al
toroidal966383toroidal
torsional945033torsional
trial54926353t_r_i_al
tribal8611133t_r_ibal
tribunal10104673tribunal
tubal75517203tu_b__al
tubbing123510093tubbin_g
tubing93813093tu_bin_g
tubings10336483tu_bings
tuitional946043tuitional
turban8310483turb__an
turbaned1145623turbaned
turbans939563turban_s
turbid979713turbi__d
turbidly1443683turbidly
turbinated1344413turbinated
turbinates1245773turbinates
turbit8715113turbi__t
turbith1267113turbi_th
turbiths1374083turbiths
turbits969233turbi_ts
turbocar1243363turbocar
turbofan1342593turbofan
turdine8310273turdin_e
turfing113010053turfin_g
turning83713183turnin_g
turnings9287233turnings
umbonal1144383_umbonal
uncinal959963_uncinal
urbia7311143_urbi_a_
urbias839093_urbi_as
urial54823023_ur_i_al
urinals7610253_ur_inals
virginal1244573virginal

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162789.28315745.1
3Display Results78780.0302600.0
 (SQL Overall)178691789.48618837.3
 
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.