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

40 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
greenfields165155(None) 
greenfield1552151greenfield_
grainfields1651102grainfields
brownfields205843brownfields
grainfield1551443grainfield_
greenbelts1352453green_belts
greenflies1443583greenflie__s
greenheads1542993green_heads
greenies9312673green_ie__s
brickfields235854brickfields
brownfield1951234brownfield_
canfields1542834__canfields
cornfields1641754_cornfields
goldfields1651214g_oldfields
greenbelt1243974green_bel_t
greenbriers1452264greenbrie_rs
greened93111264green__e_d_
greeneries1167074greenerie__s
greenfinch1951814greenfi_nch
greenfinches2161044greenfinches
greenfly1554084greenf__l_y
greenhead1443164green_head_
greenie8310124green_ie___
greenier938714green_ie__r
greeniest1039034green_ie_st
greenings11266664green_i_ngs
greenlets1044704green_le_ts
greenlights1652024greenlights
greenlings1243594greenli_ngs
greenmailed1551764greenmailed_
greenmailers1561504greenmailers
greenmails1382784greenmail_s
greenness1046794green_ne_ss
greensands1252574green_sands
greenswards1651574greenswards
greenwings1542704greenwi_ngs
greenwoods1553024green_woods
infields1244014___infields
minefields1691954mine_fields
treenails945564treenai_l_s

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.406440125.6
2DLD Change Limit148819408.61017284.4
3Display Results40400.0162500.0
 (SQL Overall)178691409.03219784.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.