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

179 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
capfuls143653(None) 
canfuls1248421canfuls
capful1368181capful_
carfuls1249131carfuls
cupfuls1444341cupfuls
lapfuls1234501lapfuls
bagfuls1334752bagfuls
cagefuls1484342cagefuls
canful11610262canful_
capsule1137352capsule
capsules1236632capsules
carful11610972carful_
cauls75727772ca__uls
cupful1356422cupful_
earfuls1036862earfuls
hatfuls1386022hatfuls
jarfuls1754772jarfuls
lapful1156482lapful_
panfuls1237182panfuls
vatfuls1384852vatfuls
ampuls1098893_ampuls
annuls64711733_annuls
appals104812943_appals
appels104312793_appels
appulse1134673_appulse
armfuls1275013armfuls
awful1178143_awful_
babuls105413643ba_buls
bagful1237213bagful_
boatfuls1344823boatfuls
boxfuls19113603boxfuls
cabals104020153ca_bals
cactus104912233cactu_s
cafes106426923ca_f_es
caffs135417373ca_f_fs
cageful1356483cageful_
caiques18248793caiques
calculi1146563calculi
calculus1255333calculus
calfs104919383calf__s
calls75634733ca__lls
callus85317073callu_s
calques182710193calques
camails11311753camails
camels105217083ca_mels
camphols1746243camphols
campouts1436823campouts
campus125213923campu_s
canals84421673ca_nals
cancels114113313cancels
cangues10611823cangues
cannels93413363cannels
cannula937443cannula
cannulas1037593cannulas
cansful1236833cansful_
cantals93919573cantals
cantus85117763cantu_s
canula8312973ca_nula
canulas9312863ca_nulas
capable13313363capable
capably1639253capably
capers105428143cap_ers
capes95441923cap__es
caphs124515373cap__hs
capias10318353cap_ias
capitals12209453capitals
capitols12247333capitols
capitula1244993capitula
capizes20410373capizes
capless114312763capless
caplets114914523caplets
caplins113515993caplins
capons104119503cap_ons
caporals1238923caporals
capos94826073cap__os
capotes11314643capotes
capouch1644413capouch
cappers134419403cappers
capris10415083cap_ris
caps87147893cap___s
capsids1239333capsids
capsular1245413capsular
capsuled1334543capsuled
captans111612053captans
captors113914983captors
capture1138913capture
captures1239443captures
caput9823983cap_u_t
caraculs1238033caraculs
carcels114516063carcels
careful1249113careful_
carls77037423ca__rls
carols85124983ca_rols
carolus94612603carolus
carpals113414633carpals
carpels115315463carpels
carpools1237883carpools
carpus105514303carpu_s
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
casques18278983casques
casuals91410543casuals
casus76419253ca_su_s
catfall1237393catfall
catfalls1347063catfalls
catguts1045323catguts
catsups1135343catsups
caucus1039613caucu_s
caul65630003ca__ul_
cauld85318443ca__uld
caulds95512383ca__ulds
caules85927253ca__ules
caulis85320083ca__ulis
caulk115315453ca__ulk
caulks125611863ca__ulks
causals91411183causals
cavils114014393ca_vils
chapels14429153chap_els
consuls92412323consuls
copals105018943cop_als
copouts11311083copouts
copula102812053cop_ula
copulas113811573cop_ulas
cupels10310203cup_els
cuprums1334453cuprums
cupsful1453433cupsful_
cupula10328443cup_ula
cupule103410723cup_ule
cupules113210263cup_ules
cyprus1335363cypru_s
earful958963earful_
eyefuls1343843eyefuls
farfals13268503farfals
farfels13348213farfels
hamauls12387823hamauls
handfuls15115753handfuls
hatful12108743hatful_
hauls86123733ha__uls
headfuls1544313headfuls
hopefuls1644073hopefuls
jarful1646683jarful_
jugfuls1843063jugfuls
lapels83712043lap_els
lapsus8437273lapsu_s
lawful1235493lawful_
manful11610213manful_
mauls76524953ma__uls
mugfuls1344003mugfuls
pagefuls1474343pagefuls
pailfuls1343853pailfuls
palmfuls1543473palmfuls
panful1179743panful_
pappus9408373pappu_s
papula103011123pap_ula
papule102212133pap_ule
papules112411573pap_ules
pipefuls1543753pipefuls
potfuls1236293potfuls
puls65437563__p_uls
rackfuls1744643rackfuls
rappels11448803rappels
sackfuls1744163sackfuls
sapours93610623sapours
sauls55128123sa__uls
scapula1136353scap_ula
scapulas1246143scap_ulas
scoopfuls1642203scoopfuls
tankfuls1543803tankfuls
tinfuls1036593tinfuls
topful1136543topful_
topfull1244153topfull
trayfuls1443483trayfuls
tubfuls1245483tubfuls
vapours12277463vapours
vatful12107083vatful_
waeful1238123waeful_
wamefuls1643873wamefuls
wauls86120553wa__uls

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 Filter1786911340270.440406115.9
2DLD Change Limit1340271796.28021341.9
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.78326343.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.