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

102 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
chaptering1810796(None) 
chartering16109251chartering
chattering16108641chattering
cantering122417382c_antering
capering132414962c_ap_ering
capturing1436622c_apturing
catering112019912c_a_tering
chaffering22104642chaffering
chambering20116042chambering
chamfering21125332chamfering
chastening1656522chastening
chippering2045162chippering
chittering16107182chittering
choppering2064812choppering
chuntering1647802chuntering
clattering13109232clattering
cratering12312652cra_tering
haltering132212012_haltering
shattering1498282shattering
altering91917123__altering
bantering122414243_bantering
bartering122313653_bartering
battering122715153_battering
blattering13108723blattering
cambering16109873c_ambering
cankering162110793c_ankering
careering12311203c_areering
centering122915143c_entering
chairing143110773cha__iring
changeling1745673changeling
channeling1645203channeling
chanting143413533chant__ing
chaperon1547353chap_eron_
chaperone1646563chap_erone
chaperoning1952633chap_eroning
chaperons1646893chap_erons
chapping183710723chap__ping
chapter144213853chapter___
chapteral1644703chapter_al
chaptered17176803chapter_ed
chapters154012133chapter__s
charactering2053713charactering
charing133721323cha___ring
charring142913163cha__rring
charting142614193chart__ing
chasseing1554963chasse_ing
chastising1654883chastising
chatting142810143cha_t_ting
cheapening1883803cheap_ening
checkering2244403checkering
cheering143612703ch__eering
chequering2543123chequering
chowdering2044163chowdering
ciphering17217703c_iphering
clabbering17104583clabbering
clambering1776163clambering
clavering1538373cla_vering
clustering13116813clustering
cluttering13106833cluttering
coappearing1842763coappearing
coapting133511613coapt__ing
compeering1747053compeering
compering163414163comp_ering
coopering142611323coop_ering
coppering162810893c_oppering
countering13314473countering
craterings1346003cra_terings
cyphering20175243c_yphering
diapering1339033diap_ering
faltering132211123_faltering
flattering1498743flattering
gartering112111593_gartering
hammering1737633_hammering
hampering1738863_hampering
hankering17239383_hankering
happening1735593_happening
hastening13259483_hastening
havering152211053_ha_vering
lappering14258843_lappering
mastering122315313_mastering
mattering122314063_mattering
nattering102212223_nattering
paltering122612903_paltering
papering132213313_pap_ering
pattering122314433_pattering
philtering1646253philtering
plastering1339243plastering
quartering2045853quartering
rapturing1245363_rapturing
realtering1139473realtering
rechartering1853543rechartering
scattering1398013scattering
sceptering1545793sceptering
sheltering1446493sheltering
shuttering1496563shuttering
smattering1397583smattering
spattering13107793spattering
tapering112112503_tap_ering
tattering102212333_tattering
waitering13310723_waitering
watering122316323_wa_tering
yattering132410453_yattering

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.406440125.6
2DLD Change Limit1406031026.65621124.2
3Display Results1021020.0601700.0
 (SQL Overall)1786911027.12225090.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.