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 “jingler” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
jingler15431109(None) 
jangler153811831jangler
jingle143815221jingle_
jingled164111061jingled
jinglers16408761jinglers
jingles153816381jingles
jinglier1655231jinglier
mingler104213841mingler
tingler83613341tingler
angler74017862_angler
binger94923452bing_er
bungler104611482bungler
dangler96912812dangler
dinger85323672ding_er
dingier93513672dingier
dingle84317072dingle_
dingles93818322dingles
finagler12194952finagler
finger104920332fing_er
giggler101029882giggler
ginger84920032ging_er
higgler12369802higgler
hinger104723332hing_er
ingle64120432_ingle_
ingles74420872_ingles
jangle144416292jangle_
jangled164111562jangled
janglers16319372janglers
jangles154015682jangles
janglier1656112janglier
jigger155313052ji_gger
jiggier16377822jiggier
jiggle153811992jiggle_
jiggled17358842jiggled
jiggles164111432jiggles
jigglier1754092jigglier
jingly174111932jingl_y
jingoes153811442jingoes
jinker174013542jin_ker
joggler16398832joggler
jongleur1642022jongleur
juggler16418872juggler
jungle144012652jungle_
jungled16349642jungled
jungles154112542jungles
junglier1644302junglier
kindler12309982kindler
kinglet123114042kinglet
kinglier1345632kinglier
linger75226002ling_er
lingier84113382lingier
mangler103215642mangler
mingier103815292mingier
mingle93518782mingle_
mingled113612732mingled
minglers113011292minglers
mingles103719002mingles
niggler93610292niggler
pinger94324092ping_er
ringer74526062ring_er
ringlet82818172ringlet
shingler12268632shingler
singer74227312sing_er
single74520602single_
singled93914682singled
singles83520432singles
singlet84120112singlet
tangler83515072tangler
tingle74319062tingle_
tingled93712802tingled
tinglers93710592tinglers
tingles83818322tingles
tinglier956402tinglier
tinkler113610542tinkler
wangler113312652wangler
wiggler123110762wiggler
winger104125442wing_er
wingier113413282wingier
winglet113115982winglet
zinger163816702zing_er
zingier17369492zingier

Search took 3 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 Filter1786911076710.1431249587.4
2DLD Change Limit107671812.70339833.9
3Display Results81810.0302700.0
 (SQL Overall)178691812.87662131.8
 
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.