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

105 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
liberals103941(None) 
liberal9310191liberal_
literals8312291literals
laterals8312752laterals
libels85112692libe__ls
liberalise1247592liberalise
liberalism1447042liberalism
liberalist1249062liberalist
liberally1446262liberally
liberate101113382liberate
liberates111012942liberates
libers84721442liber__s
libras83711702lib_ra_s
literal7613272literal_
minerals10311392minerals
beryls11107883__beryls
bimetals1246953bimetals
borals86721913__borals
citrals91111673ci_trals
dihedrals1443473dihedrals
federals1247303federals
ferals94216643__ferals
fibers114717523fiber__s
fibrils1236843fib_rils
funerals1146453funerals
generals9109343generals
gibers95114663giber__s
gomerals1147453gomerals
hibernal1344413hibernal_
humerals1347183humerals
ideals75012503_ide_als
illegals954323illegals
illiberal1152983illiberal_
jibers155912883jiber__s
labels84515683labe__ls
labials9299873lab_ials
lateral7313573lateral_
legals73412733l__egals
libbers113812833libber__s
libel74116103libe__l_
libelant1048563libelant
libelants1145303libelants
libelees10227213libelees
libelers10238623libelers
libelous1047193libelous
liber74723623liber___
liberalised1445203liberalised
liberalises1346833liberalises
liberalisms1546203liberalisms
liberalists1346403liberalists
liberality1545903liberality
liberalize2146953liberalize
liberalizes2246423liberalizes
liberalness1354513liberalness
liberated1299473liberated
liberator1147063liberator
liberators1247013liberators
liberties1149203liberties
liberty1237163liber_ty
liblabs1144123lib_labs
libra74712423lib_ra__
librae84310173lib_ra_e
library1245323lib_rary
librate93214233lib_rate
librates103412953lib_rates
lienal63912793li_enal_
liernes739623li_ernes
liers55130403li_er__s
lifers95617843lifer__s
lifeways1743893lifeways
ligers75022043liger__s
likers104620913liker__s
limberly1544463limber_ly
limbers113614743limber__s
lineal65616033line_al_
linearly1146793linearly
liners65428853liner__s
linguals9317223linguals
lipreads1144223lipreads
liras56021983li__ra_s
literacy1346803literacy
literalism1248853literalism
literalist10411533literalist
literally1248343literally
literary1147753literary
literate81216893literate
literates91415653literates
literati81210803literati
literatus9146823literatus
liters65429883liter__s
litoral7610763litoral_
littorals944133littorals
liveries11314373liveries
livers94927823liver__s
livetraps1442543livetraps
mineral9312743mineral_
mistrals101212633mistrals
neoliberals1351803neoliberals
numerals1047343numerals
pibals103813083pib__als
pineals93212853pine_als
puberal1147773puberal_
ribgrass1143423ribgrass
ruderals946073ruderals
severals1137593severals

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621057.31319986.6
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.79522923.8
 
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.