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

63 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
dividable164500(None) 
decidable1547222decidable
devisable1546852devisable
divisible1544382divisible
advisable1544573advisable
avoidable15124743avoidable
biddable14165673bi_ddable
bindable13169623bi_ndable
definable1547773definable
demisable1448533demisable
deniable11312083deni_able
derivable1548063derivable
desirable1249393desirable
dilatable1246853dilatable
dimmable1536113di_mmable
dippable1536123di_ppable
dirigible1343173dirigible
disable10516433d__isable
disenable1249673disenable
dislikable1744323dislikable
divide113410893divid___e
dividedly1842813dividedly
dividual1344053dividual_
divisibly1843233divisibly
drainable1237583drainable
drivable1438023d_rivable
driveable1544523driv_eable
dubitable1445093dubitable
dutiable1137373duti_able
enviable1337853envi_able
evadable1436363_evadable
evitable1339323_evitable
findable14179023fi_ndable
giveable14155753giv_eable
guidable1236203_guidable
hidable1399403__hidable
imitable1239123_imitable
inviable1338523invi_able
leviable1337513levi_able
limitable1345643limitable
litigable1244223litigable
livable122010323liv__able
liveable13177663liv_eable
mitigable1444753mitigable
navigable1544743navigable
obviable1543863obvi_able
oxidable1865123_oxidable
pitiable1238293piti_able
pivotable1644563pivotable
revisable1437993revisable
revivable1736863revivable
ridable101412493__ridable
slidable1137953_slidable
subdividable2161183subdividable
unridable1248293unridable
unviable1338703unvi_able
viable111613773__vi_able
visitable1445873visitable
vitiable1337503viti_able
voidable1466853_voidable
wieldable1543813wieldable
windable14159153wi_ndable
yieldable1543353yieldable

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.420425454.8
2DLD Change Limit148641636.83021763.0
3Display Results63630.0134846.2
 (SQL Overall)178691637.26324602.9
 
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.