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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
backlog163577(None) 
backlogs1746631backlogs
backflow2243372backflow
backhoe1847152backhoe
backing165523442backing
backlit15911902backlit
backload1746832backload
beclog1136862bec_log
blackleg1734232blackleg
jackleg2135032jackleg
analog7159973_analog
apolog938903_apolog
bacalao1146613bacalao
bacalaos1245863bacalaos
bachelor1564073bachelor
baching156017753baching
bacilli1146393bacilli
back125535763back___
backbit17129103backbit
backblock2043273backblock
backbone1847443backbone
backcloth2294563backcloth
backdoor1744693backdoor
backdrop19114253backdrop
backed155725723back_ed
backer144525523back_er
backers153821883backers
backfit18108213backfit
backflip2143093backflip
backflows2343873backflows
backhoed2047003backhoed
backhoes1938543backhoes
backings174012213backings
backland1748103backland
backlash1945923backlash
backless162910633backless
backlight2155703backlight
backlist16910653backlist
backloads1846293backloads
backlogged2152963backlogged
backmost1846633backmost
backout15612953backout
backroom1846093backroom
backs135729623back__s
backsaw1836203backsaw
backset15314193backset
backslap1844993backslap
backslid1746273backslid
backstop1845563backstop
backup1646613back_up
backups1736173backups
backwood2046973backwood
bacon95620593bac__on
bacula103112673bacul_a
baculum1345703baculum
bailor83412603ba_ilor
baking135626623ba_king
balking143717353balking
ballon84117493ba_llon
ballot84624093ba_llot
bandog1038723ba_ndog
banking144621353banking
barking144724183barking
barlow112911423ba_rlow
basking144718613basking
becking164416073becking
beckon14309383beck_on
beclogs1237073bec_logs
bicolor1145613bicolor
blackboy2143163blackboy
blacking174213603blacking
blacklegs1843913blacklegs
blackly1835253blackl_y
blacktop1842973blacktop
blog75723823b___log
bucking163617573bucking
buckle144815193buckl_e
buckled164411883buckled
buckler154112033buckler
buckles153416093buckles
buckling17259113buckling
bucko134614023buck_o_
buckos143710893buck_os
cackle143416923cackl_e
cackled164613293cackled
cackler153812573cackler
cackles153717203cackles
cackling172610943cackling
catalog1038003catalog
clog76123243__c_log
colog86619933__colog
decalog1136003decalog
hacking173720613hacking
hackle154916813hackl_e
hackled173312483hackled
hackler163512353hackler
hackles162917063hackles
hackling183310163hackling
hackly18298733hackl_y
jacking214515263jacking
jacklegs2233953jacklegs
jackpot2245013jackpot
lacking143821543lacking
mackle143716433mackl_e
mackled164111913mackled
mackles154415753mackles
mackling172710063mackling
magalog1144913magalog
packing164420723packing
packly17228333packl_y
racking144323663racking
rackle123917293rackl_e
sacking144122703sacking
sawlog1035793sa_wlog
tacking144421483tacking
tackle123815733tackl_e
tackled143913183tackled
tackler134013323tackler
tackles133816523tackles
tackling153211123tackling
unclog956603unc_log
wacko145514383wack_o_
wackos155210993wack_os
yacking174315683yacking

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271245.96622465.1
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.16828970.7
 
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.