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

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
frequenters235264(None) 
frequenter2243411frequenter_
frequences2444932frequence_s
frequented2343422frequente_d
frequentest2352652frequentest
frequentness2451822frequentness
frequents2144442frequent__s
requesters1944322_requesters
fermenters15116533f_ermenters
forequarters2451623forequarters
frequence2344803frequence__
frequencies2553943frequencies
frequent2046423frequent___
frequenting2443273frequenting
frequently2553813frequent_ly
fresheners1643863freshen_ers
presenters1239863pre_senters
preventers1547393pre_venters
reenters82915303_re__enters
repenters112511553_re_penters
requester1855513_requester_
requestors1943183_requestors
requiters18176553_requ_iters
sequencers2143093_sequencers
sequesters1943843_sequesters
banqueters2143144banque_ters
briquettes2183384briquette_s
cementers1338314_ce_menters
croquettes2143544croquette_s
decenters122410374_de_centers
fermenter1497544f_ermenter_
fermentors1594234f_ermentors
ferreters1246254f_erre_ters
flaunters1234514f_lau_nters
fomenters1437854f__omenters
forequarter2362094forequarter_
forerunners14162304foreru_nners
foxhunters2341704foxhu_nters
fraudsters1441914fr_audsters
freebooters1652054freebooters
freelancers1652354freelancers
freeness11710444fre__en_ess
freezers20307174fre__e_zers
freighters1764124fre_ighters
frequency2653404frequen__cy
frequentnesses2661424frequentnesses
freshener1544854freshen_er_
freshwaters2052214freshwaters
fretters113410304fr___etters
fruiters11328184fr__u_iters
greeters92610114gre__e_ters
grunters9359034gr__u_nters
infrequences2653304infrequence_s
orienters937614or__ienters
precentors1488344pre_centors
preeners102712814pre__en_ers
preheaters1557194pre_heaters
presentees1247924pre_sentees
presenter11311644pre_senter_
pretenders1345244pre_tenders
preventer1438594pre_venter_
questers17168764___questers
rebutters1195094_rebu_tters
recanters112310484_re_canters
recenter102715444_re_center_
recounters1246214_recounters
reenter73217794_re__enter_
refunders1334974_refu_nders
refuters11449614_refu__ters
regretters1144094_regretters
reheaters122010274_re_heaters
reinters82614774_re__inters
rejecters18257544_re_jecters
reletters9138784_re_letters
renters74224814_r___enters
repeaters112811994_re_peaters
repenter102813864_re_penter_
reprinters1295794_reprinters
requested1935894_requeste_d
requestor1853024_requestor_
requests1735744_request__s
requirers18165004_requ_irers
requiter17168644_requ_iter_
requites171511764_requ_ite_s
resetters9129464_re_setters
respecters1445864_respecters
retreaters1047544_retreaters
returners9376554_return_ers
reuniters936424_re_uniters
reutters8138574_re_u_tters
revengers1336414_re_vengers
revenuers1235984_re_venuers
reverters122710434_re_verters
roquettes1855064_roquette_s
sequencer2044574_sequencer_
sequences2067014_sequence_s
sequents1756994_sequent__s
sequester1844444_sequester_
squinters1835524__squinters
unfrequented2551844unfrequente_d

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191008.31017908.4
3Display Results1001000.0502000.0
 (SQL Overall)1786911008.78320345.1
 
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.