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

210 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
unrifled123742(None) 
rifled104115002__rifled
trifled113711962_trifled
unbilled1188692unbilled
unbridled1344972unbridled
undrilled1146662undrilled
unfilled1298382unfilled
ungifted13116832ungifted
unified112413572un_ified
unmilled1197852unmilled
unoiled82415482unoi_led
unpiled102312742unpi_led
unreeled91310332unreeled
unribbed1334172unribbed
unriddled1243812unriddled
unrigged1165642unrigged
unrimed102211632unri_med
unrinsed938382unrinsed
unripped1335762unripped
unrivaled1345242unrivaled
unrolled9610412unrolled
unruffled1672922unruffled
unruled8311372unr_uled
unsifted12128772unsifted
untilled9710562untilled
untitled978762untitled
unwilled1277822unwilled
aerified121310133aerified
anviled1138953anvi_led
anvilled1236483anvilled
ariled75620323_ari_led
auricled11135703auricled
bridled113611143_bridled
drifted12367953_drifted
drilled94711673_drilled
enisled82510223en_isled
enriched1435863enriched
enrolled967963enrolled
ensiled82611433ensi_led
entitled967503entitled
frilled113911603_frilled
grifted12379583_grifted
grilled94012833_grilled
intitled967343intitled
knifed14528123kn_if_ed
nailed74021493_nai_led
nilled73919453_n_illed
nurled74016233nur__led
periled10316323peri_led
perilled11410113perilled
prilled104713003_prilled
purfled13248733pur_fled
purified1438743purified
rarified1239053rarified
riffed133811563__riffed
riffled14338603__riffled
rifle85518333__rifle_
rifler94014263__rifler
rifles94217703__rifles
rifted104115313__rifted
riled65833253__ri_led
rilled74525653__rilled
serifed11811463serif_ed
seriffed1594973seriffed
shrilled1246863shrilled
snaffled15285213snaffled
snailed83811923snai_led
sniffed14318183sn_iffed
sniffled15276443sniffled
snuffled15277033snuffled
stifled113511093_stifled
tariffed1533723tariffed
thrilled1235493thrilled
trifle94012883_trifle_
trifler103912153_trifler
trifles103814823_trifles
trilled84116313_trilled
tripled104113833_tripled
uglified1345293uglified
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unaneled939793unaneled
unbaled103315963un_baled
unbiased1147153unbiased
unbitted1138213unbitted
unboiled112410373unboiled
unbridged1453923unbridged
unbridle1145393unbridle_
unbridles1244133unbridles
unbriefed1553523unbriefed
unbroiled1235803unbroiled
uncalled11810923uncalled
unchilled1545563unchilled
uncoiled112512683uncoiled
uncooled112710633uncooled
uncrippled1742553uncrippled
uncuffed1734083uncuffed
uncurled1168963uncurled
undefiled1446113undefiled
undimmed1434113undimmed
undried92314613undri__ed
undulled1036993undulled
unfed94614223un__f_ed
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unfoiled12249723unfoiled
unfurled1277203unfurled
ungalled1078463ungalled
ungirded1136083ungirded
unhailed12219963unhailed
unhealed121511073unhealed
unhinged13257473unhinged
unhired112512153unhi_red
unifier102211863un_ifier
unifies102714713un_ifies
unironed939083unironed
united74421543un_i_ted
unkeeled13117183unkeeled
unkindled1594203unkindled
unkinked12215903unkinked
unkissed1334893unkissed
unled64021073un___led
unlicked15248263unlicked
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmailed11229763unmailed
unmined102612953unmi_ned
unmingled1344283unmingled
unmitred1136843unmitred
unmixed17228213unmi_xed
unmuffled1872343unmuffled
unnailed9229443unnailed
unpeeled11118533unpeeled
unpicked17237213unpicked
unpile81914323unpi_le_
unpiles92112783unpi_les
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unpolled1168943unpolled
unpriced1338143unpri_ced
unprimed1337203unpri_med
unprinted1238133unprinted
unprized2038513unpri_zed
unraised91811883unraised
unraked122914013unr_aked
unranked1338563unranked
unrated82621553unr_ated
unraveled1345543unraveled
unrazed172511453unr_azed
unreeler8127293unreeler
unreeved12117673unreeved
unrefined1345463unrefined
unrented92413923unrented
unrested91914513unrested
unrhymed1742853unrhymed
unriddle1043983unriddle_
unriddler1142783unriddler
unriddles1143503unriddles
unripe82012093unri_pe_
unripely1344633unripely
unripened1244393unripened
unriper9188283unri_per
unrisen7229283unri_sen
unrivalled1443243unrivalled
unrobed102711213unr_obed
unroofed12106773unroofed
unrooted9810513unrooted
unroped102812103unr_oped
unrumpled1443673unrumpled
unrushed12247573unrushed
unrusted92310353unrusted
unscaled111410113unscaled
unsealed91513623unsealed
unshifted16124943unshifted
unsigned1037563unsigned
unsized172510543unsi_zed
unskilled1444603unskilled
unsoiled92412083unsoiled
unspilled1245093unspilled
untidied1038903untidied
untied73720813unti__ed
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untried82615853untri__ed
untrimmed1443563untrimmed
untufted1236083untufted
untwilled1343873untwilled
unveiled1298163unveiled
unwalled1288653unwalled
unwifely1743603unwifely
unwished15237833unwished
unwitted1237543unwitted
unwrinkled1841923unwrinkled
unzipped2233213unzipped
uplifted1454423uplifted
uppiled12216593uppi_led
utricle937913utricle_
utricles1037223utricles
verified151510393verified

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622106.42322756.0
3Display Results2102100.0932258.1
 (SQL Overall)1786912106.93925751.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.