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

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

118 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
reputable137912(None) 
deputable1487031deputable
refutable1477861refutable
reputably1686451reputably
imputable1546682imputable
rebuttable1443952rebuttable
refusable1476682refusable
refutably1785332refutably
regulable1246512regulable
relatable11310052relatable
rentable101716332re_ntable
reparable1359952reparable
repayable1666342repayable
repeatable1447602repeatable
reportable1446952reportable
restable101618442re_stable
resumable1347552resumable
retable91820402re__table
reusable10811272re_usable
beatable121612243be_atable
computable1855713computable
creatable1339563cre_atable
creditable1546003creditable
debatable1446313debatable
deletable12149503deletable
denotable1238373denotable
depletable1544963depletable
deportable1545653deportable
deposable1446833deposable
disputable1545063disputable
disreputable1752763disreputable
eatable91717603_e_atable
editable11310423_editable
educable1337083_educable
equable1849253_equ_able
equatable2045193_equatable
equitable2046183_equitable
erectable131210093erectable
eruptible1342913eruptible
evitable1339323_evitable
executable2144033executable
getable101712553ge__table
getatable1235953getatable
gettable11178133ge_ttable
heatable131612043he_atable
heritable1439453heritable
immutable1545593immutable
imputably1845343imputably
irrefutable1653983irrefutable
meltable12310473me_ltable
mutable11312303__mutable
nestable101613673ne_stable
nettable101610243ne_ttable
permutable1644983permutable
perusable1347453perusable
pettable121710713pe_ttable
potable112115363__potable
presumable1645203presumable
ratable91717553r__atable
reachable16129653reachable
readable11313163re_adable
reapable12311393re_apable
recoupable1645023recoupable
redoubtable1652123redoubtable
reducible1444673reducible
reefable1339533re_efable
reelable10311593re_elable
referable1439623referable
refinable1438623refinable
refundable1643803refundable
refutal1046943refuta_l_
refutals1165503refuta_ls
relaxable1836363relaxable
relegable1258103relegable
reliable10313073re_liable
relivable1438513relivable
remittable1445743remittable
removable1646923removable
renewable1447433renewable
repairable1445953repairable
reparably1656353reparably
repealable1445983repealable
replicable1646623replicable
reptile93914083rep_t_ile
repute84716093reput___e
reputedly1543343reputedly
resalable1138733resalable
rescuable1347583rescuable
resectable1478123resectable
resettable1256513resettable
respectable1755043respectable
respirable1446023respirable
restabled12148953re_stabled
restables111511423re_stables
retables101712673re__tables
returnable1244793returnable
reuptake1443463reupta_ke
reusables1175223re_usables
reverable14310363reverable
revisable1437993revisable
revivable1736863revivable
revocable1647003revocable
revokable1845293revokable
rippable1435383rip_pable
ropable111611333rop__able
rotatable1146653rotatable
rulable9310533r__ulable
rustable101511363r_ustable
scrutable1346043scrutable
securable1347773securable
separable1348673separable
temptable1545813temptable
tenurable1147423tenurable
testable101412623te_stable
treatable1139323tre_atable
vegetable1545683vegetable
veritable1448743veritable
wettable13148043we_ttable

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411188.75016987.5
3Display Results1181180.0631873.0
 (SQL Overall)1786911188.98319892.1
 
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.