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

114 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
revisable143799(None) 
devisable1546851devisable
revivable1736861revivable
advisable1544572advisable
demisable1448532demisable
evitable1339322_evitable
leviable1337512levi_able
previable1647532previ_able
raisable10311642r_aisable
refinable1438622refinable
refusable1476682refusable
reliable10313072reli_able
relishable1544522relishable
relivable1438512relivable
reusable10811272re_usable
reverable14310362reverable
reviewable1843432reviewable
revisal1038262revisa_l_
revisals1136812revisa_ls
revocable1647002revocable
revokable1845292revokable
seisable10311372se_isable
advisably1843073advisably
creditable1546003creditable
decidable1547223decidable
definable1547773definable
deniable11312083deni_able
deposable1446833deposable
derisible1245773derisible
derivable1548063derivable
desirable1249393desirable
devisal1136913devisa_l_
devisals1245613devisa_ls
disable10516433__disable
dividable1645003dividable
divisible1544383divisible
editable11310423_editable
enviable1337853envi_able
erasable10511043_erasable
evadable1436363_evadable
evocable1537103_evocable
excisable2045053excisable
exilable1737203_exilable
heritable1439453heritable
inevitable1557643inevitable
inviable1338523invi_able
invisible1446073invisible
leasable101510133le_asable
medicable1647503medicable
navigable1544743navigable
obviable1543863obvi_able
perishable1745263perishable
perusable1347453perusable
predicable1747193predicable
radiable11611303radi_able
raiseable1147243r_aiseable
reachable16129653reachable
readable11313163re_adable
realizable2145333realizable
reapable12311393re_apable
receivable1745513receivable
reclosable1444893reclosable
reefable1339533re_efable
reelable10311593re_elable
referable1439623referable
refillable1544073refillable
refutable1477863refutable
registrable1452933registrable
regulable1246513regulable
relatable11310053relatable
relaxable1836363relaxable
releasable1245483releasable
relegable1258103relegable
reliables1145903reli_ables
reliably1339243reli_ably
relievable1544663relievable
remissible1444343remissible
remittable1445743remittable
removable1646923removable
renewable1447433renewable
rentable101716333re_ntable
repairable1445953repairable
reparable1359953reparable
repayable1666343repayable
replicable1646623replicable
reputable1379123reputable
resalable1138733resalable
resale64025543re__sa_le
rescuable1347583rescuable
resistible1244613resistible
respirable1446023respirable
restable101618443re_stable
resumable1347553resumable
retable91820403re__table
reusables1175223re_usables
revealable1545083revealable
reversible1574903reversible
revile94921613revi___le
revise94019743revis___e
revival1337033reviva_l_
revivals1435433reviva_ls
revocably1944573revocably
revolvable1843513revolvable
ridable101412493r__idable
rinsable10310043r_insable
risible937923r__isible
ruinable1039263r_uinable
seizable1938723se_izable
severable1438543severable
teasable101511173te_asable
unviable1338703unvi_able
veritable1448743veritable
viable111613773__vi_able
visible1236923__visible

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411147.39020113.8
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.84222786.4
 
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.