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

148 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
lawful123549(None) 
awful1178141_awful
lapful1156481lapful
bagful1237212bagful
canful11610262canful
capful1368172capful
carful11610972carful
earful958962earful
hatful12108742hatful
jarful1646682jarful
lapfuls1234502lapfuls
lawfully1743502lawfully
manful11610212manful
panful1179742panful
playful1544652playful
unlawful1441782unlawful
vatful12107082vatful
waeful1238122waeful
afoul8510193_afoul
aidful1057073aidful
aimful1166703aimful
ampul91110853_ampul
annul55813383_annul
armful1167163armful
artful968273artful
awfully1644003_awfully
awl67635303_aw__l
awol75620673_aw_ol
babul96317713ba_bul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1237993baleful
baneful1237893baneful
bashful1556553bashful
bawl95326063baw__l
blameful1543813blameful
boatful1236283boatful
bowlful1544613bowlful
boxful18145273boxful
cageful1356483cageful
canfuls1248423canfuls
cansful1236823cansful
capfuls1436523capfuls
careful1249113careful
carfuls1249133carfuls
caul65630003ca__ul
cupful1356423cupful
dareful1157053dareful
earfuls1036863earfuls
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
farfal123410183farfal
farfel124310433farfel
fateful1397513fateful
fearful1345593fearful
fitful1256333fitful
gainful1145833gainful
glassful12113553glassful
gleeful1144323gleeful
hamaul114210863hamaul
handful14127253handful
hangul1049213hangul
harmful1535763harmful
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
haul75530453ha__ul
headful1445563headful
ireful948713ireful
jarfuls1754773jarfuls
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
label75019383la_bel
labial84714333labial
labium10410233labium
labour84210933labour
labrum1057423labrum
ladleful1243273ladleful
laical8312323laical
lall45531313la__ll
langue71012173langue
langur7109303langur
lapel73716683la_pel
lapsus8437273lapsus
larrup835713larrup
larum74317973la_rum
larval948503larval
latu47934183la_tu_
laud56527723la__ud
laurel649033laurel
law68656643law___
lawed96028323law_ed
lawine93316463lawine
lawing104625283lawing
lawman11289053lawman
lawmen11308593lawmen
lawn75925633law__n
lawns85215423law_ns
lawny115912013law_ny
laws76441683law__s
lawsuit1044953lawsuit
lawyer12386973lawyer
layout9513703layout
layup1037723la_yup
lazuli1535363la_zuli
lifeful1344613lifeful
loathful1443383loathful
lungful1144013lungful
lustful1045283lustful
maul64830713ma__ul
moanful12105003moanful
mugful1235403mugful
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panfuls1237173panfuls
pawl95123263paw__l
plateful1345433plateful
potful1138083potful
rackful1645873rackful
rueful948203rueful
sackful1645353sackful
saul45836523sa__ul
sawfly1535133sawfly
sinful938803sinful
sobful1136333sobful
swayful1643003swayful
tactful1236163tactful
tankful1445153tankful
tearful1046033tearful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tubful1136683tubful
useful947013useful
vatfuls1384853vatfuls
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
waul76927313__waul
wawl105321943waw__l
wilful1235963wilful
woeful1236363woeful
woful1158173_woful
yawl104918973yaw__l

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161485.62620034.8
3Display Results1481480.0463217.4
 (SQL Overall)1786911485.81230745.2
 
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.