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

152 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
fitful125633(None) 
fistful1365901fistful
aidful1057072aidful
aimful1166702aimful
artful968272artful
factful1536372factful
faithful1743382faithful
fateful1397512fateful
fistfuls1454562fistfuls
fitfully1744992fitfully
fretful1346142fretful
fruitful1443552fruitful
hatful12108742hatful
kistful1465302kistful
pitiful1245862pitiful
potful1138082potful
sinful938802sinful
tinful938042tinful
vatful12107082vatful
wilful1235962wilful
wistful1365712wistful
armful1167163armful
awful1178143_awful
bagful1237213bagful
biofuel1243293biofuel
boatful1236283boatful
boxful18145273boxful
brimful1443883brimful
canful11610263canful
capful1368173capful
carful11610973carful
citral81113893citral
citrus83610923citrus
cupful1356423cupful
direful1156613direful
dishful1455433dishful
dutiful1144763dutiful
earful958963earful
eyeful1235903eyeful
faithfuls1842303faithfuls
faitour1034883faitour
farfal123410183farfal
farfel124310433farfel
fatal84819373fat_al
fearful1345593fearful
feastful1444923feastful
fetal85623373fet_al
fetial95716193fetial
fetus85816543fet_us
fibril1137163fibril
fibula11258053fi_bula
fichu134810663fichu_
fichus14388113fichus
ficus105015493fi_cus
fief107331363fief__
fiefs116213703fief_s
fife106027703fi_f_e
fifed125115973fi_fed
fifer115519973fi_fer
fifes114822393fi_fes
fifth145210923fi_fth
fifthly1943093fifthly
fifths15406543fifths
fifty145211423fi_fty
fil65447143fi___l
filial93013253filial
fill75540193fi__ll
filum105015433fi_lum
final83922033fi_nal
finial92814183finial
fique1739143fi_que
fiscal1139333fiscal
fistula1045503fistula
fit66365453fit___
fitch134816873fit_ch
fitchy17437623fitchy
fitly115114973fit_ly
fits76043463fit__s
fitted104716663fitted
fitter94120033fitter
forkful1744773forkful
formful1545183formful
foul77027583f__oul
frightful1952553frightful
fulfil1246423fulfil
furfur1235553furfur
gainful1145833gainful
hateful13107683hateful
hatfuls1386023hatfuls
hatsful13106193hatsful
hurtful1344853hurtful
ireful948713ireful
jarful1646683jarful
jestful1745333jestful
joyful1943843joyful
jugful1734603jugful
kistfuls1553833kistfuls
kittel10368873kittel
lapful1156483lapful
lawful1235493lawful
lifeful1344613lifeful
lightful1544163lightful
litmus836323litmus
litu47631563lit_u_
lustful1045283lustful
manful11610213manful
miaul71612123mi_aul
mindful1344613mindful
mirthful1642853mirthful
mitral81314323mitral
moistful1343853moistful
mugful1235403mugful
nitril62511533nitril
pailful1236103pailful
painful1246403painful
panful1179743panful
picul95015363pi_cul
pipeful1445643pipeful
pitfall1245823pitfall
potfuls1236293potfuls
poutful1236743poutful
restful1038623restful
rightful1544233rightful
ritual6310623ritual
rueful948203rueful
ruthful1344503ruthful
situp74414063sit_up
situs55019233sit_us
skilful1443933skilful
skinful1444193skinful
sobful1136333sobful
spiteful1344303spiteful
tactful1236163tactful
tinfuls1036593tinfuls
titfer9409523titfer
tittup834203tittup
toilful1044813toilful
topful1136543topful
tristful1144933tristful
tubful1136683tubful
useful947013useful
vatfuls1384853vatfuls
vital84819673vit_al
waeful1238123waeful
wailful1344953wailful
willful1344533willful
wishful1664503wishful
withal1238933withal
wittol935923wittol
woeful1236363woeful
woful1158173_woful
zestful1945243zestful

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 Limit1127161524.92322895.8
3Display Results1521520.0463304.3
 (SQL Overall)1786911525.10934975.7
 
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.