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

174 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
unfilmed149580(None) 
unfilled1298381unfilled
filmed124610362__filmed
infirmed14205342infirmed
refilmed14235812refilmed
unaimed102812492unai_med
unbilled1188692unbilled
undimmed1434112undimmed
unfelted1279402unfelted
unfired112212452unfi_red
unfished15218292unfished
unfitted1238162unfitted
unfixed18218562unfi_xed
unfoiled12249722unfoil_ed
unfolded1338312unfolded
unformed14239572unformed
unframed1478242unframed
unhelmed1435992unhelmed
unmilled1197852unmilled
unoiled82415472unoil_ed
unpiled102312742unpil_ed
unrimed102211632unri_med
untilled9710562untilled
untilted9610892untilted
untimed102713372unti_med
unwilled1277822unwilled
affirmed1743213affirmed
anviled1138943anvil_ed
anvilled1236483anvilled
confirmed1745563confirmed
defiled124013103defil_ed
enfilade1243743enfilade
enfiladed1442993enfiladed
enflamed1455723enflamed
enfolded1345433enfolded
enframed1466263enframed
engilded1143983engilded
ensiled82611433ensil_ed
filed95331903__fil_ed
filled104922263__filled
filmer114112403__filmer
firmed125411883__firmed
fulfilled1642693fulfilled
infixed18206563infi_xed
inflamed1446033inflamed
infolded1375663infolded
informed14197673informed
nailed74021493_nail_ed
nilled73919453_n_illed
nimmed11368573_n_immed
refiled114318653refil_ed
refilled12278673refilled
snailed83811923snail_ed
unaided92414603unai_ded
unaired82916013unai_red
unallied938393unallied
unarmed101811923un_armed
unbaled103315963unbal_ed
unbelted1179333unbelted
unbiased1147153unbiased
unbitted1138213unbitted
unblamed1337193unblamed
unboiled112410373unboil_ed
unbolted1179323unbolted
uncalled11810923uncalled
unchilled1545563unchilled
uncoiled112512683uncoil_ed
undefiled1446113undefil_ed
undiluted1144903undiluted
undrilled1146663undrilled
undulled1036993undulled
unfaded123111733unf_aded
unfaked153211173unf_aked
unfallen1144463unfallen
unfazed20299053unf_azed
unfeared121511013unfeared
unfed94614223unf___ed
unfeigned1453293unfeigned
unfenced1437733unfenced
unfilial1145343unfilial
unfiltered1443563unfiltered
unfixes17238113unfi_xes
unflawed1536123unflawed
unflexed1935253unflexed
unfluted1237173unfluted
unfold10179703unfol__d
unfolder12216583unfolder
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unfreed11510123unf_reed
unfunded1336473unfunded
unfurled1277203unfurled
unfused11319513unf_used
ungalled1078463ungalled
ungelded1147403ungelded
ungifted13116833ungifted
ungirded1136083ungirded
unglued937303un_glued
unhailed12219963unhail_ed
unhalved1556513unhalved
unharmed1438093unharmed
unhelped1435923unhelped
unhinged13257473unhinged
unhired112512153unhi_red
unified112413573un_ified
uniformed1544533uniformed
unilobed1136393un_ilobed
united74421543un_i_ted
unjammed2033623unjammed
unkinked12215903unkinked
unkissed1334893unkissed
unled64021073un__l_ed
unlicked15248263unlicked
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmailed11229763unmail_ed
unmelted1169183unmelted
unmined102612953unmi_ned
unmitred1136843unmitred
unmixed17228213unmi_xed
unmolded1237453unmolded
unnailed9229443unnail_ed
unnamed102410273un_named
unpicked17237213unpicked
unpile81914323unpil_e_
unpiles92112783unpil_es
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unpolled1168943unpolled
unprimed1337203unprimed
unrhymed1742853unrhymed
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrinsed938383unrinsed
unripped1335763unripped
unrolled9610413unrolled
unruled8311373unrul_ed
unsalted9510923unsalted
unseamed111210663unseamed
unshamed14148053unshamed
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unskilled1444603unskilled
unsliced1138093unsliced
unsoiled92412083unsoil_ed
unsolved1237833unsolved
unspilled1245093unspilled
untamed102913223un_tamed
untidied1038903untidied
untied73720813unti__ed
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untrimmed1443563untrimmed
untwilled1343873untwilled
unvalued1266313unvalued
unveiled1298163unveil_ed
unwalled1288653unwalled
unwarmed1437303unwarmed
unwelded1337133unwelded
unwished15237833unwished
unwitted1237543unwitted
unzipped2233213unzipped
upfolded1542883upfolded
uppiled12216593uppil_ed
uptilted1174683uptilted

Search took 8 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.1561145455.1
2DLD Change Limit1461621747.59319249.6
3Display Results1741740.0802175.0
 (SQL Overall)1786911747.82922824.2
 
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.