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

120 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
shielders133476(None) 
shielder1235181shielder_
fielders12156772_fielders
shedders13267432sh_edders
shellers112812582sh_ellers
shelters113412812sh_elters
shelvers14388812sh_elvers
shielded1334392shielde_d
shields11538042shield__s
shoulders1334232shoulders
shredders1463712shredders
spielers10319652spiel_ers
wielders12196612_wielders
yielders12164742_yielders
builders1146743bui_lders
cheders134512393ch_e_ders
chiders135312943chi__ders
chields13507483chield__s
childes134211273chi_lde_s
chillers133710923chi_llers
chiselers1445453chisel_ers
chisellers1543093chisellers
elders74817303___elders
fielder11217413_fielder_
gelders93812573__gelders
gilders94212463_gi_lders
guilders1035513gui_lders
headers113819393_h_eaders
heders104119763_h_e_ders
heeders114213743_h_eeders
heelers103815633_heel_ers
hellers103619833_h_ellers
helpers123311853_h_elpers
herders113914123_h_erders
hiders104919653_hi__ders
hillers103718733_hi_llers
hinders113718503_hi_nders
holders113715903_h_olders
infielders1442623infielders
melders103213913__melders
philters1398173phi_lters
sailers73822323sai_l_ers
schillers14285663schi_llers
scolders11288993s_colders
seceders11277963sece_ders
seders74420283s__e_ders
seeders83017113s__eeders
sellers73721323s__ellers
senders83022353s__enders
shaders115915553sh__aders
shearers113911323sh_earers
shedder12339323sh_edder_
sheers94322403sh_e__ers
sheeters113111863sh_eeters
sheller103515893sh_eller_
shelter103214963sh_elter_
shelver134211063sh_elver_
shelves134112093sh_elve_s
shewers134312053sh_e_wers
shickers173012823shi_ckers
shield106212973shield___
shielding1434553shielding
shielings13237123shielings
shiels95418923shiel___s
shiers94921753shi___ers
shifters14319863shi_fters
shikkers14326523shi_kkers
shimmers15269413shi_mmers
shiners104015943shi__ners
shinglers13246443shinglers
shipless13277693shipl_ess
shippers153012313shi_ppers
shirkers15319583shi_rkers
shitless11249243shitl_ess
shiverers15155773shiverers
shivers133714833shi__vers
shoeless1137803shoel_ess
shoulder1234753shoulder_
shovelers15174943shovel_ers
shovellers16173783shovellers
shredder1334403shredder_
shrewder1534403shrewder_
shriekers16224423shrie_kers
shudders13316643sh_udders
sidlers83414233s_idl_ers
sillers73822103s_i_llers
silvers104714043s_i_lvers
skelters12349373s_kelters
skidders1454823ski_dders
sledders10257373s_ledders
sliders83515223sli__ders
smellers10329773s_mellers
smelters103310513s_melters
smilers94113853smi_l_ers
smolders11287193s_molders
smoulders1243143smoulders
snivelers1264533snivel_ers
snivellers1352873snivellers
solders83517773s__olders
speeders11339313s_peeders
spellers102812763s_pellers
spelters103912243s_pelters
spenders113211743s_penders
spiders103914413spi__ders
spieler93111233spiel_er_
spillers103311703spi_llers
spindlers12286453spindlers
spreaders1236503spreaders
stiflers11238833stifl_ers
swelters113110193s_welters
swillers11299113swi_llers
swindlers13306033swindlers
threaders1365743threaders
welders113313413__welders
wheedlers1643203wheedlers
wheelers14287743wheel_ers
whirlers14286053whirl_ers
wielder11197673_wielder_
wilders113513503_wi_lders
yielder11175113_yielder_

Search took 9 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 Filter1786911486411.110160982.9
2DLD Change Limit1486411207.54619698.0
3Display Results1201200.0631904.8
 (SQL Overall)1786911208.71920494.4
 
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.