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

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

49 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
outfielders155148(None) 
outfielder1451951outfielder_
outfields1373122outfield__s
fielders12156773___fielders
infielders1442623_infielders
midfielders1851233midfielders
outbidders1442063outbi_dders
outfield1265253outfield___
outfitters1342753outfi_tters
outriders10237223outri__ders
outsiders10236663outsi__ders
outyielded1541903outyielde_d
outyields1362133outyield__s
builders1146744bu__i_lders
fielder11217414___fielder_
fulfillers1642044fulfi_llers
guilders1035514gu__i_lders
infielder1343174_infielder_
midfielder1751344midfielder_
offenders1643404o__ffenders
outbidder1343154outbi_dder_
outdelivers1551764out_delivers
outfables1485564outfabl_e_s
outfeels1135064outf_e__els
outfences1456464outf_ence_s
outfigures1442304outfigure_s
outfinds1235644outfi_nd__s
outfires1139864outfi__re_s
outfishes15118024outfi_she_s
outfitter1243914outfi_tter_
outflies11310154outf__lie_s
outlanders1144274out_landers
outliers82610674out___liers
outliners9228364outli__ners
outlivers12246154outli__vers
outrider92410564outri__der_
outrides92414994outri__de_s
outriggers1242964outri_ggers
outsider9269644outsi__der_
outsides92513234outsi__de_s
outsteers936034outste__ers
outwiles1139234outwi_l_e_s
outyield1263724outyield___
outyielding1642444outyielding
shielders1334764__shielders
subfields1543304subfield__s
unfolders1344724_unf_olders
wielders12196614___wielders
yielders12164744___yielders

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819498.70317099.7
3Display Results49490.0133769.2
 (SQL Overall)178691499.13919552.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.