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

45 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
snickerers1613358(None) 
snickerer15134561snickerer_
bickerers17115592_bickerers
sickeners1535732s_ickeners
slickeners1643662slickeners
snickered16115342snickere_d
snickers143010962snick__ers
sniggerers1242192sniggerers
bickerer16106773_bickerer_
cricketers1843903cricketers
knickers13306723knick__ers
nickered15117023_nickere_d
nickers134415093_nick__ers
pickeers16347243_picke_ers
pickerels1743723_pickerels
picketers17196483_picketers
puckerers1744513_puckerers
quickeners2542763quickeners
shickered19115723shickere_d
shickers173012823shick__ers
shiverers15155773shi_verers
sickees134514213s_icke_e_s
sickener1436603s_ickener_
silverers12215753s_ilverers
simperers1335933s_imperers
sincerer1037203sinc_erer_
slackeners1643423slackeners
slickener1544043slickener_
slickers143112553slick__ers
slicksters1643393slicksters
sliverers12196363sli_verers
snackers143010223snack__ers
sneerers8309803sn__eerers
snicker133012673snick__er_
snickering1744863snickering
snickersnees1861333snickersnees
snickery17295543snick__ery
sniggerer1142723sniggerer_
snivelers1264533sni_velers
snorkelers1442273snorkelers
sorcerers1145323sorc_erers
stickers142913033stick__ers
sticklers15227393stick_lers
thickeners1943463thickeners
tinkerers1395423_tinkerers

Search took 8 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 Filter1786911406030.436409841.7
2DLD Change Limit140603457.12619731.0
3Display Results45450.0133461.5
 (SQL Overall)178691457.57523589.6
 
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.