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 “fruitfuller” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
fruitfuller175148(None) 
fruitfullest1862552fruitfullest
fruitfully1953192fruitfull_y
fruitful1443553fruitfu_l__
fruitfulness1854883fruitfulness
restfuller1363253_restfuller
beautifuller1761004beautifuller
fearfuller1651804f_earfuller
fitfully1744994f__itfull_y
fretfully1844304fr_etfull_y
friller104111744fr_i___ller
frivoller1542434fr_i_voller
fruiter10309684fruit____er
fruiterer1243334fruit__erer
fruitier1136594fruit___ier
fruitlet1146884fruit___let
frustule1154484frust_u_le_
frustules1244664frust_u_les
fulfiller1542784f_u_lfiller
gracefuller1752284gracefuller
gratefuller1552184gratefuller
mournfuller1661024mournfuller
painfuller1552204_painfuller
pitifuller1551664__pitifuller
spitefuller1651384_spitefuller
trustfully1653594trustfull_y
unfruitfully2161764unfruitfull_y
artfully1445405ar__tfull_y
awfuller1442425___awfuller
brailler1036885brai___ller
brimfull1542545br_imfull__
brimfully1943285br_imfull_y
brittler10165985br_it__tler
bruiter93710635bruit____er
carefuller1542715_carefuller
cheerfuller1991385cheerfuller
crestfallen1651925crestfallen
crueller1056455cru___eller
cruller968755cr____uller
dolefuller1451915_dolefuller
doubtfully1952455doubtfull_y
driller84311885dr_i___ller
driveller1353855dr_i_veller
dutifully1643905_dutifull_y
faithfully2252805f_aithfull_y
fastballer1551975f_astballer
faultfinder185845faultfinder
filler94623625f__i___ller
fitful1256335f__itfu_l__
fitfulness1645735f__itfulness
footballer1552995f_ootballer
forestaller1453255forest_aller
foreteller1353305foret_eller
forgetfully2152255forgetfull_y
fracturer14134625fract_u_rer
frailer10319945frai____ler
frankfurter21121205frankfurter
fretful1346145fr_etfu_l__
fretfulness1776225fr_etfulness
fribbler15265955fr_i__bbler
friendlier1441825fr_iendlier
frightfully2452085frightfull_y
frilled113911605fr_i___lled
frillers11349875fr_i___llers
frillier1136515fr_i__llier
fritillary1651725fr_it_illary
fritter103912775fr_it___ter
fritterer12234405fr_it_terer
frivoler1443935fr_i__voler
frivolled1642385fr_i_volled
frivollers1642075fr_i_vollers
frizzler19345845fr_i__zzler
frizzlier20122885fr_i_zzlier
fruitage1244345fruit__age_
fruitages1344485fruit__ages
fruitcake1851605fruit_cake_
fruitcakes1951745fruit_cakes
fruited11389095fruit____ed
fruiterers1343005fruit__erers
fruiters11328185fruit____ers
fruitfulnesses2094635fruitfulnesses
fruitily1445145fruit__il_y
fruitless1244165fruit__less
fruitlets1243175fruit__lets
fruitlike1642855fruit__like
fueller10279965f_u___eller
fulfilled1642695f_u_lfilled
fulfillers1642045f_u_lfillers
fuller94220385_____fuller
griller84513355gr_i___ller
grueller935335gru___eller
hurtfully1843655_hurtfull_y
joyfuller2251475__joyfuller
kruller1145155kr____uller
lustfully1543795_lustfull_y
outpulled1245255_ou_tpulled
peacefuller1872005peacefuller
restfullest1454135_restfullest
restfully1545555_restfull_y
riffler13328355_r_i_f_fler
rifler94014265_r_i_f__ler
ruefully1445225_ru_efull_y
ruffler13369725_ru__f_fler
rufflier1434015_ru__fflier
rustler73512345_rust___ler
ruthfully1843645_ruthfull_y
thankfuller2151365thankfuller
trifler103912155tr_i_f__ler
triller74215895tr_i___ller
tristfully1653745tristfull_y
trustbuster1361085trustbuster
trustful1144375trustfu_l__
trustfulness1565065trustfulness
truthfully1952965truthfull_y
unfruitful1651585unfruitfu_l__
unfruitfulness2062015unfruitfulness
woefuller1542105__woefuller
wofuller1442405___wofuller

Search took 15 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 Filter1786911646070.436409841.7
2DLD Change Limit16460711814.37611450.1
3Display Results1181180.0631873.0
 (SQL Overall)17869111814.87512012.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.