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

183 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
ireful94871(None) 
direful1156611direful
armful1167162armful
artful968272artful
careful1249112careful
dareful1157052dareful
dirgeful1343252dirgeful
eyeful1235902eyeful
fretful1346142fretful
irefully1445942irefully
lifeful1344612lifeful
pipeful1445642pipeful
refel84920812_refel
refuel93912622_refuel
rueful948202rueful
useful947012useful
waeful1238122waeful
woeful1236362woeful
aidful1057073aidful
aimful1166703aimful
areal55928733are_al
armfuls1275013armfuls
armsful1284093armsful
awful1178143_awful
bagful1237213bagful
baleful1238003baleful
baneful1237893baneful
befoul1137253_befoul
boxful18145273boxful
brimful1443883brimful
cageful1356483cageful
canful11610263canful
capful1368173capful
carful11610973carful
credal9311673credal
creel75121483cre_el
crenel84213063crenel
cresol8310213cresol
cresyl1135133cresyl
crewel114310483crewel
cupful1356423cupful
defuel10348933_defuel
direfully1644783direfully
dishful1455433dishful
doleful1146333doleful
dreadful1343223dreadful
dreamful1452963dreamful
dreidl835233dreidl
earful958963earful
easeful1037293easeful
eyefuls1343843eyefuls
fateful1397513fateful
firebug1383793firebug
firefly1635633firefly
fistful1365903fistful
fitful1256333fitful
forceful1644603forceful
forkful1744773forkful
formful1545183formful
frenula1045623frenula
frenum1188803frenum
gleeful1144323gleeful
graceful1445393graceful
grateful1245403grateful
guileful1243313guileful
harmful1535763harmful
hateful13107683hateful
hatful12108743hatful
heedful1444313heedful
hopeful1545903hopeful
hurtful1344853hurtful
icefall1254303icefall
ideal65716393ide_al
ileal56118083ile_al
ileum74512823ile_um
ileus54616893ile_us
inhaul936803inhaul
insoul638463insoul
ire36943173ire___
ired55131873ire__d
irenic8311103irenic
ires45639283ire__s
irreal657833irreal
iterum837903iterum
jarful1646683jarful
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
kistful1465303kistful
lapful1156483lapful
lawful1235493lawful
manful11610213manful
mindful1344613mindful
mirthful1642863mirthful
mugful1235403mugful
museful1245883museful
needful1143863needful
pageful1346353pageful
panful1179743panful
peepul1035783peepul
pipefuls1543753pipefuls
pitiful1245863pitiful
potful1138083potful
prebuy1357423prebuy
precut102016533precut
prefab1336243prefab
prefer113813203prefer
prefile123413183prefile
prefix18356853prefix
prefund1335733prefund
prequel1836343prequel
prevue1179163prevue
prideful1443913prideful
real45750293_re_al
rebel73421293_rebel
rebus75721113_rebus
rebut75927383_rebut
rebuy104714683_rebuy
recur74116843_recur
recut74729243_recut
redub84212413_redub
redux133811103_redux
reel45240533_re_el
ref66053293_ref__
refall94314393_refall
refed93921923_refed
refeel93913243_refeel
refell94214443_refell
refels94618053_refels
refelt94521423_refelt
refer84822143_refer
refile95122373_refile
refill94514053_refill
refilm114311403_refilm
refit84230063_refit
refix155212483_refix
reflux16315413_reflux
refly113914563_refly
refold103812113_refold
refry114412463_refry
refs75732243_ref_s
reft75141273_ref_t
refuels10399523_refuels
refuge105312613_refuge
refund104810303_refund
refusal1056893_refusal
refuse94817513_refuse
refutal1046943_refutal
refute95515703_refute
regal65023793_regal
reguli738143_reguli
renal55929503_renal
reoil55321183_reoil
repel74921403_repel
rerun58722153_rerun
restful1038623_restful
result6318223_result
revel84423163_revel
revue81114453_revue
riel46432383rie__l
sinful938803sinful
sobful1136333sobful
spiteful1344303spiteful
teenful1045563teenful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tref77030993tref__
trefah1235093trefah
trefoil1066063trefoil
tubful1136683tubful
tuneful1046123tuneful
ureal56722683ure_al
vatful12107083vatful
voiceful1643053voiceful
wakeful1735613wakeful
wameful1535673wameful
wilful1235963wilful
willful1344533willful
wishful1664503wishful
wistful1365713wistful
woful1158173_woful
wreckful2042443wreckful

Search took 7 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.373479064.3
2DLD Change Limit1127161835.83019333.8
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.26628517.6
 
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.