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

97 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
reliables114590(None) 
reliable10313071reliable_
relabels1045342rel_abels
reliably1339242reliabl_y
reliances1139622reliances
relivable1438512relivable_
restables111511422restables
retables101712672re_tables
reusables1175222reusables
alliable1038433alliable_
belittles1143873belittles
breakables1842753breakables
celibates1358633celibates
deniable11312083deniable_
desirables1344213desirables
eatables10169793_eatables
edibles1048003_edi_bles
eligibles12113063_eligibles
enables92813123_e_nables
fellable13179133fellable_
fetiales11319613fetia_les
gelable101710733gel_able_
helpable1536603helpable_
leviable1337513leviable_
liable81415813__liable_
meltable12310473meltable_
pliable111610323_pliable_
predicables1843813predicables
previable1647533previable_
radiable11611303radiable_
ratables10159723r_atables
readable11313163readable_
reales64934123re__a_les
realizable2145333realizable_
reapable12311393reapable_
receivables1852463receivables
recircles1344433recircles
redialed10310793redia_led
redialled1145883redialled
redials84416883redia_l_s
redoubles1244263redoubles
reefable1339533reefable_
reelable10311593reelable_
refiles104122423refi__les
refinable1438623refinable_
regales83520793re_ga_les
rekindles1443863rekindles
relabel938163rel_ab_el
relabeled1243923rel_abeled
relaces93420883rel_a_ces
relapses1038033rel_apses
relatable11310053relatable_
relates73731433rel_a_tes
relaxable1836363relaxable_
relaxes143215323rel_a_xes
releases8313343relea_ses
relegable1258103relegable_
reliableness1457133reliableness
reliance10310473reliance_
relies65036423reli___es
relievable1544663relievable_
relieves114210393reli_eves
relines75331323reli__nes
reliques1736903reli_ques
relishable1544523relishable_
relishes11311953reli_shes
relives104619443reli__ves
renewables1543403renewables
rentable101716333rentable_
replicable1646623replicable_
resales74724903re_sa_les
rescales103414573resca_les
resembles1376073resembles
resiles74026543resi__les
restable101618443restable_
restabled12148953restabled
retable91820403re_table_
reticles103912483reti_cles
reticules1139013reticules
retiles74426993reti__les
retitles83612593reti_tles
reusable10811273reusable_
reviles104421353revi__les
revisable1437993revisable_
revivable1736863revivable_
risibles1035783risi_bles
rulable9310533rul_able_
sellable101711823sellable_
sociables1344963sociables
syllables14144753syllables
tellable10169773tellable_
unreliable1248483unreliable_
valuables1442973valuables
variables1444673variables
vendables15165153vendables
wearables14155003wearables
weldable1436863weldable_

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.420425454.8
2DLD Change Limit148641978.03318503.8
3Display Results97970.0462108.7
 (SQL Overall)178691978.49921024.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.