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

47 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
ensnarers98357(None) 
ensnarer874471ensnarer_
ensnares856891ensnare_s
insnarers954431insnarers
enslavers1243882enslavers
ensnare767122ensnare__
ensnared965292ensnare_d
ensnarls873392ensnar_ls
ensurers8279372ens_urers
insnarer865302insnarer_
insnares858082insnare_s
snarers74216662__snarers
answerers1243743answerers
censurers11256073cens_urers
enchasers1445093enchasers
endangers1144943endangers
endpapers1443643endpapers
endurers9317953en_durers
engagers10246553en_gagers
engravers1344313engravers
enhancers1445103enhancers
enlargers1043493en_largers
enslaver1144713enslaver_
enslaves1136393enslave_s
ensnaring1046383ensnaring
ensnarl784913ensna__rl
ensnarled1042913ensnarled
ensurer73011903ens_urer_
ensures73315903ens_ure_s
enterers82214153en_terers
escapers12337413e_scapers
essayers1133563e_ssayers
gennakers1442793gen_nakers
insnare748243insnare__
insnared956123insnare_d
inspirers1143963inspirers
insurers83710133ins_urers
scarers94618513__scarers
sharers104720623__sharers
snarer64620843__snarer_
snares65329033__snare_s
snarlers8298753__snarlers
snorers74313803__snorers
soarers74118093__soarers
sparers94519613__sparers
starers74522313__starers
unsnarls894883unsnar_ls

Search took 7 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 Filter1786911486410.453394461.4
2DLD Change Limit148641476.25023782.6
3Display Results47470.0162937.5
 (SQL Overall)178691476.71926594.9
 
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.