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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
upfield134303(None) 
afield1035952_afield
field95015322__field
infield1135822infield
outfield1265252outfield
subfield1444752subfield
upfold12124952upf_old
upheld12115562up_held
uppiled12216592uppiled
airfield1243143airfield
bield84614653__bield
canfield1444333canfield
chield124610213_chield
defied115016383defie_d
defiled124013103defiled
fields104211043__fields
fiend95312983__fiend
filed95331903__filed
fjeld16465583__fjeld
hayfield18102073hayfield
infields1244013infields
midfield15203843midfield
misfield14265913misfield
outfields1373123outfields
outyield1263723outyield
pied75035363_p_ie_d
piled85232993_p_iled
plied85118593_plie_d
pried84426863_prie_d
puffed153510603puffe_d
refiled114318653refiled
shield106212973_shield
speiled104412123speiled
spied85427713sp_ie_d
spiel74623913sp_iel_
spieled104811883sp_ieled
spiels85317953sp_iels
spiled94621993sp_iled
spoiled104811353spoiled
subfields1543303subfields
unfed94614223unf_e_d
unfelt92413463unf_elt
unfilled1298383unfilled
unfired112212453unfired
unfitly1335573unfitly
unfixed18218563unfixed
unfoiled12249723unfoiled
unfold10179703unf_old
unfreed11510123unfreed
unified112413573unifie_d
unoiled82415473unoiled
unpiled102312743unpiled
untied73720813untie_d
unwieldy1542413unwieldy
upbind11246313upbi_nd
upboiled13194853upboiled
upbuild1243003upbuild
upcoiled13215183upcoiled
updived1434093updived
updried11226473updrie_d
upend85011043up__end
upfolds13133753upf_olds
upgird10103933upgi_rd
uphill11106173uphi_ll
uphills1295233uphills
uphold12126903up_hold
upped103715163up_pe_d
uppile10178503uppi_le
uppiles11208263uppiles
upsend9356883up_send
upsized19246253upsized
upswell1242723upswell
uptilt8410803upti_lt
uptrend1044293uptrend
upwell11285793up_well
upwind12255823upwi_nd
wield95213913__wield
yield9519693__yield

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.203880251.2
2DLD Change Limit134027786.03322215.6
3Display Results78780.0302600.0
 (SQL Overall)178691786.26628517.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.