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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
retrainable134435(None) 
restrainable1452801restrainable
retractable1545122retractable
trainable1138942__trainable
attainable1243743_attainable
determinable1754023determinable
distrainable1553633distrainable
drainable1237583__drainable
obtainable1443363obt_ainable
reclaimable1753013reclaimable
refinable1438623re__finable
repairable1445953re_pairable
retrainee9511163retrain__ee
retrievable1652553retrievable
returnable1244793ret_urnable
stainable1138093_st_ainable
terminable1476603te_rminable
ascertainable1761264ascertainable
containable1546204containable
declinable1545864de_clinable
definable1547774de__finable
defrayable1943254defra_yable
degradable1543884degra_dable
derivable1548064de_r_ivable
detachable1844614det_achable
determinably2053544determinably
detonable1247624det__onable
eradicable1545634_e_radicable
erasable10511044_e_ra_sable
examinable2144094_examinable
explainable2252524explainable
extractable2254154extractable
extraditable2253054extraditable
extricable2144744extr_icable
gainable1138934___gainable
getatable1235954get_a_table
heritable1439454he_r_itable
interminable1656894interminable
intractable1557364intractable
learnable1145564le__arnable
medicinable1852454medicinable
metastable1444924met_astable
personable1467074pe_rsonable
raisable10311644___raisable
reachable16129654re__achable
readable11313164re__a_dable
realizable2145334re_alizable
reapable12311394re__a_pable
reasonable1246284re_asonable
recallable1445374re_callable
recappable1843724re_cappable
receivable1745514re_ceivable
rectifiable1853144rectifi_able
refrangible1751904refrangible
regrettable1452984regrettable
relatable11310054re_la_table
relaxable1836364re_la_xable
releasable1245484relea_sable
reliable10313074re__li_able
relivable1438514re__livable
remarkable1844084re_markable
remediable1545134remedi_able
reparable1359954re_pa_rable
repayable1666344re_pa_yable
repealable1445984repea_lable
repeatable1447604repea_table
replaceable1743224replaceable
replicable1646624re_plicable
reproachable2152614reproachable
resalable1138734re_sa_lable
resealable1246184resea_lable
respirable1446024re_spirable
restartable1343544restartable
restrainedly1651794restrainedly
retable91820404ret____able
retinae75517334ret__ina__e
retinal75318354ret__ina_l_
retinals85612964ret__ina_ls
retractile1246254retra_ctile
retrain7615424retrain____
retrained10411314retrain__ed
retrainees1046394retrain_ees
retraining11310244retrain_ing
retrains8314534retrain___s
retrial7615554retr_i_a_l_
retrials8510824retr_i_a_ls
returnables1352124ret_urnables
revealable1545084revea_lable
revisable1437994re__visable
revivable1736864re__vivable
rewardable1643884re_wardable
rotatable1146654rot_a_table
ruinable1039264___ruinable
sustainable1352504sustainable
tannable1039384__t_annable
terminably1755554te_rminably
titratable1243694titra_table
traceable1338324__traceable
trackable1736744__trackable
tractable1338514__tractable
tradable1139874__tra_dable
tradeable1247414__tradeable
triable92515394__tr_i_able
unattainable1453394unattainable
untraceable1546854untraceable
veritable1448744ve_r_itable

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 Filter1786911488190.1731032896.0
2DLD Change Limit1488191068.71617074.2
3Display Results1061060.0631682.5
 (SQL Overall)1786911068.95219961.0
 
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.