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

100 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
outfield126525(None) 
outfields1373121outfields
outyield1263721outyield
outfeel1037542outfeel_
outfeels1135062outfeels
outfelt10310602outf_elt
outfielder1451952outfielder
outfind1139562outfi_nd
outfired1238082outfired
outvied11239692outvie_d
outwiled1237602outwiled
outyields1362132outyields
subfield1444752subfield
upfield1343032_upfield
afield1035953__afield
airfield1243143airfield
canfield1444333canfield
coalfield1541823coalfield
cornfield1542853cornfield
downfield1742133downfield
field95015323___field
goldfield1541723goldfield
hayfield18102073hayfield
infield1135823_infield
juttied15417863juttie_d
midfield15203843midfield
misfield14265913misfield
outbid91411863outbi__d
outbred10311263outbre_d
outbreed1138503outbreed
outbuild1144843outbuild
outcried1139543outcrie_d
outdid81210923outdi__d
outduel837303outduel_
outdueled1144723outdueled
outduels945053outduels
outed65429063out__e_d
outfable1378813outfable
outfabled1595093outfabled
outfaced14219463outfaced
outfall1039683outf_all
outfalls1138143outfalls
outfielders1551483outfielders
outfight1546103outfight
outfinds1235643outfinds
outfire1049713outfi_re
outfires1139863outfires
outfish132210573outfi_sh
outfished16116603outfished
outfit93014953outfi__t
outfits102210833outfi_ts
outfitted1345193outfitted
outflew1336423outfle_w
outflies11310153outflie_s
outfly1238273outf__ly
outfool1037333outfool_
outfooled1345493outfooled
outfools1136533outfools
outfound1245763outfound
outfoxed1936013outfoxed
outkill1136553outki_ll
outkilled1444753outkilled
outkills1245143outkills
outlead83311103out_lead
outled74020343out_le_d
outlie62419533outlie__
outlier72216143outlie_r
outliers82610673outliers
outlies72421993outlie_s
outlined92512953outlined
outlived12269583outlived
outread82811093out_read
outsailed1037793outsailed
outscold11115253outscold
outsell7109263out_sell
outsized18209743outsized
outsmell1075523outsmell
outsmelt10138163outsmelt
outsmiled1245673outsmiled
outsold8109073out_sold
outsped101110323outspe_d
outspeed11117933outspeed
outspell10125453outspell
outspelt10148403outspelt
outspend11126203outspend
outtell797883out_tell
outtold8107603out_told
outvie92412803outvie__
outvies102214243outvie_s
outwile10310263outwi_le
outwiles1139233outwiles
outwill1037323outwi_ll
outwilled1345013outwilled
outwills1135653outwills
outwind1139153outwi_nd
outyell1095843out_yell
outyelp1294323out_yelp
outyielded1541903outyielded
puttied103811163puttie_d
subfields1543303subfields

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.436409841.7
2DLD Change Limit1461621006.56322270.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.02925422.0
 
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.