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 “transferable” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
transferable175379(None) 
transferrable1862321transferrable
transferal1355712transfera_l_
transferals1455212transfera_ls
transferase1455452transfera_se
transformable2072272transformable
transfusable1752422transfusable
answerable1544153__answerable
nontransferable207953nontransferable
trailerable1352823tra_ilerable
transferases1555083transferases
transferee1347253transfer__ee
transference1754313transference
transfusible1762323transfusible
translatable1453053translatable
transmutable1653013transmutable
transportable1762643transportable
transposable1652743transposable
unanswerable1753123unanswerable
inferable14411274__in_ferable
preferable1746724pr__eferable
raiseable1147244_rais_e_able
referable1439624_r__eferable
renderable1397154_ren_derable
tasteable1146124t_a_ste_able
traceable1338324tra__ce_able
tradeable1247414tra__de_able
trafficable2172004tra_fficable
transaxle1645914trans___axle
transcribe1446814trans_crib_e
transdermal1453354transdermal_
transfer1138434transfer____
transferability2361934transferability
transferees1456074transfer_ees
transferences1853684transferences
transferor1394524transfer__or
transferors1484494transfer_ors
transferred1554604transfer_red
transferrer1454694transfer_rer
transferrers15133664transferrers
transferrin1454774transfer_rin
transferring1654334transferring
transferrins1554584transferrins
transfers1238054transfer___s
transmittable1762364transmittable
transversal1453494transversal_
transversals1562994transversals
transverse1345904transver__se
transversely1862514transversely
traversable1652814tra__versable
treasurable1343614treas_urable
unanswerably2062524unanswerably

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 Filter1786911247900.406440125.6
2DLD Change Limit124790526.75018487.4
3Display Results52520.0301733.3
 (SQL Overall)178691527.18624866.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.