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

54 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
sniveller125370(None) 
sniveler1155251snive_ler
snivelled1353991snivelled
snivellers1352871snivellers
driveller1353852driveller
shoveller15174542shoveller
sneller73512852sn__eller
sniveled1255462snive_led
snivelers1264532snive_lers
swivelled1662962swivelled
beveller13387693_beveller
chiseller1443973chiseller
driveler1284693drive_ler
drivelled1443983drivelled
drivellers1452953drivellers
enameller1144173enameller
frivoller1542433frivoller
groveller1354233groveller
indweller1393013indweller
leveller11317603_leveller
libeller10297433_libeller
livelier1136873_livelier
novelle1058233_novelle_
raveller11339273_raveller
reveller112912193_reveller
seller63824603s___eller
sheller103515893s__heller
shielder1235183shi_elder
shiverer14186663shive_rer
shoveler14165583shove_ler
shovelled16174413shovelled
shovellers16173783shovellers
shrivelled1742373shrivelled
siller64026063s_i__ller
sliverer11237633slive_rer
smeller94212793s__meller
snelled83313053sn__elled
sniffler14296833sni_ffler
sniggler10396113sni_ggler
snivel9368853snive_l__
sniveling1336033sniveling
snivelling1444293snivelling
snivels10336903snive_l_s
speller95415153s__peller
spieler93111233spi_e_ler
spiller92914333spi__ller
spinelle1046223spinelle_
spinelles1146083spinelles
stiller73414303sti__ller
svelter10359673s__velter
sweller103012473s__weller
swiller103211663swi__ller
swiveled1544163swive_led
traveller1266603traveller

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 Filter1786911486410.420425454.8
2DLD Change Limit148641548.36017780.0
3Display Results54540.0163375.0
 (SQL Overall)178691548.79620315.0
 
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.