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

77 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
tubulins1010629(None) 
tubulin9116431tubulin_
lupulins1044652lupulins
tabulis938832tabuli_s
tubules9310232tubul_es
tubulous1045372tubulous
ablins8316193_ab_lins
abulias93210693_abulias
aiblins9311473aib_lins
albumins1245353albumins
auburns935573aubu_rns
botulins1047063botulins
bubaline1247163bubaline
bubalis11359903bubali_s
bubblies1166773bubblies
bubbling12248223bubbling
burins84221893__burins
dubbins12358803dub_bins
dunlins849553du_nlins
globulins1244173globulins
goblins1039243gob_lins
indulins958863indulins
insulins848863insulins
inulins7311493_inulins
levulins1144803levulins
lupulin945003lupulin_
moulins9312703_moulins
muslins9312213mu_slins
nubbins11268023nub_bins
paulins9312613_paulins
publics13207143pub_lics
purlins93415423pu_rlins
rubbling13238073rubbling
subclans1247413subclans
suberins10315093suberins
subjoins1745453subjoins
subline9316893sub_line
sublines10315783sub_lines
subtilins1147173subtilins
subunits1046623subunits
tabling103216033tab_ling
taborins103310223taborins
taboulis1045043tabouli_s
tabuing10308893tabu_ing
tabuli839363tabuli__
tabuns8489223tabu__ns
theelins1137643theelins
thulias1035743t_hulias
tubbing123510093tub_bing
tubeless1037023tubeless
tubelike1436093tubelike
tuberculins1551843tuberculins
tubfuls1245483tubful__s
tubing93813093tub__ing
tubings10336483tub__ings
tublike1337083tub_like
tubular9267473tubul_ar
tubulate1038273tubulate
tubulates1147233tubulates
tubulating1345583tubulating
tubule839853tubul__e
tubulose1043893tubulose
tubulure1042773tubulure
tubulures1142623tubulures
tulips8137253t__ulips
tumbling13219293tumbling
tumblings14184843tumblings
tumpline1237113tumpline
tumplines1346023tumplines
tumuli835933tumuli__
tumulous1045303tumulous
tumults934823tumul_ts
tumulus935033tumul_us
turbulent1144463turbulent
turtling9238833turtling
turtlings10184873turtlings
tussling935823tussling

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162776.87621256.8
3Display Results77770.0302566.7
 (SQL Overall)178691777.06225303.2
 
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.