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

250 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
serrating1051320(None) 
seriating10916401seriating
aerating92821002ae_rating
berating113220762be_rating
derating103222282de_rating
ferreting13127692ferreting
narrating10310352narrating
overrating14814202overrating
perorating13313132perorating
recrating121318792recrating
regrating111316212regrating
seating84130682se__ating
secreting1279822secreting
sedating103014112se_dating
sensating1039252sensating
separating1348642separating
serration9414062serration
serrations10313092serrations
serrying12167692serr_ying
striating10914192striating
terracing1237702terracing
acerbating1546293acerbating
arraying1238753_arraying
asperating1349563asperating
aspirating1348363aspirating
barraging1337383barraging
beating104326873be__ating
bedraping1535383bedraping
beraking153612973be_raking
bereaving1537573bereaving
berrying14137373berr_ying
betraying1537713betraying
bewraying1834873bewraying
borating113414503_borating
ceratin93020163ce_ratin_
ceratins102818733ce_ratins
cerebrating1646663cerebrating
corrading1338203corrading
crating103725203__crating
creating113921953_creating
cremating14312203cremating
curating11314293_curating
deaerating12311563deaerating
debating123213733de_bating
decorating14312073decorating
defeating142311973defeating
deflating142610713deflating
defraying1735853defraying
degrading13137373degrading
delating103119603de_lating
departing1349513departing
depraving1635973depraving
depurating1438643depurating
deratting1139513deratting
derogating1348633derogating
desecrating1548093desecrating
detracting1438713detracting
deviating14311083deviating
disrating11714553disrating
eating75134403_e__ating
elating83423083_e_lating
enervating1488433enervating
enraging1049573_enraging
equating18310113_equating
erasing8317963_e_rasing
erecting112415063_erecting
erratic9311123_errati_c
erratics1046983_erratics
erring73816483_err__ing
eructing112110173_eructing
erupting11218443_erupting
estating92614993_estating
estraying1338293estraying
estreating11710363estreating
execrating2047883execrating
federating1548853federating
fellating1339253fellating
ferreling13136273ferreling
ferretings14133493ferretings
ferritin1147383ferritin_
ferritins1247273ferritins
ferruling13134423ferruling
ferrying15146243ferr_ying
furcating1537783furcating
garroting1136953garroting
gelating103015733ge_lating
gemmating1576443gemmating
generating12310383generating
gestating11229983gestating
grating93923183__grating
gyrating1337453_gyrating
hearting12513123hear_ting
heating114024323he__ating
herniating1445983herniating
herring113615883herr__ing
herrying15147023herr_ying
hurrahing1643753hurrahing
hurraying1654323hurraying
hydrating1746323hydrating
iterating10314253iterating
keratin113314153ke_ratin_
keratins122313483ke_ratins
lariating10311793lariating
legating102313113le_gating
librating1239053librating
mediating13311203mediating
mercurating1645953mercurating
meriting11314683me_riting
migrating13910533migrating
misrating121014853misrating
negating102012833ne_gating
nitrating10312673nitrating
obsecrating1644133obsecrating
operating12313723operating
orating83520323__orating
outrating10916403outrating
overeating141016533overeating
overhating17910953overhating
parroting1239153parroting
perforating1747023perforating
permeating1539923permeating
permuting1446553permuting
pervading1636303pervading
pirating11314513_pirating
prating103424453__prating
predating13514653predating
prorating12314283prorating
rating74938703___rating
rebating112418343re_bating
recoating121317463recoating
recreating131214583recreating
redating102620173re_dating
redrafting1545963redrafting
redrawing1437213redrawing
reflating132514713reflating
refracting1638733refracting
reframing1538623reframing
regrading121210203regrading
regrafting1545993regrafting
regranting1238323regranting
reheating132314913reheating
relating92725443re_lating
remating112322423re_mating
repeating122618983repeating
replating122217403replating
rereading111212713rereading
rerenting102617663rerenting
rerouting10311873rerouting
reseating102421533reseating
reslating102516993reslating
restating102319413restating
retracing12313293retracing
retracting13311933retracting
retreating111414773retreating
rewriting13310413rewriting
satiating10311813satiating
sating74735453s___ating
saturating11119203saturating
scarting113415263scar_ting
scraping133310863s_craping
screaking16228243screaking
screaming14217833screaming
scripting1437473scripting
seafaring1345963seafaring
sealing83528563se__aling
seaming103222113se__aming
searching1538343searching
searing83330923se__aring
seatings93614303se__atings
secretin10108343secretin_
secretins11108463secretins
seesawing1343653seesawing
segregating1445453segregating
selecting12310533selecting
serenading1246103serenading
serging93416673se_r_ging
seriatim1049223seriati_m
seriation9318063seriation
seriations10316683seriations
sering74731813se_r__ing
serotine8313573se_rotine
serotiny1148573se_rotiny
serranid947573serrani_d
serranids1045533serranids
serrano768463serra__no
serrate73017543serrat__e
serrated92513433serrat_ed
serrates82617023serrat_es
serrature945003serrature
servicing1545343servicing
serving113014983se_r_ving
setting83621393se__tting
shirting123213613shir_ting
shorting122514803shor_ting
sinuating1039683sinuating
situating1038883situating
skating123613853s__kating
skirting13289393skir_ting
slating83724653s__lating
smarting113212453smar_ting
snorting92613373snor_ting
solating9315593s_olating
solvating1336443solvating
sorrowing1344873sorrowing
sorting83221813s_or_ting
speciating1548123speciating
spectating1546623spectating
spiraling1237953spiraling
spiriting1238413spiriting
spirting112913633spir_ting
sporting112415463spor_ting
spraying14299883s_praying
spreading1339653spreading
sprinting12310033sprinting
sprouting1236943sprouting
spurting113111633spur_ting
starting93116173star_ting
stating83725163s__tating
strafing122111193s_trafing
strawing122411623s_trawing
straying122912693s_traying
streaking142010323streaking
streaming12239653streaming
strunting1037873strunting
strutting1037003strutting
sublating12310983sublating
sulfating1338063sulfating
summating1437943summating
surfacing1545643surfacing
surnaming1245143surnaming
surrogating13194323surrogating
surtaxing1784143surtaxing
susurrating12114013susurrating
sweating123213023s_weating
terrain7410853terra_in_
terrains8410323terra_ins
terrapin1046203terrapin_
terrapins1146183terrapins
threating131010053threating
throating1398403throating
titrating10310113titrating
treating92519613_treating
uncrating12813183uncrating
underrating1388253underrating
uprating11311113_uprating
variating13310953variating
venerating14410053venerating
vibrating1537483vibrating
warranting1444743warranting
worriting1345553worriting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486412506.51622811.7
3Display Results2502500.1062358.5
 (SQL Overall)1786912507.05825317.5
 
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.