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

342 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
hirsling127754(None) 
hireling121210991hireling
hirpling1467221hirpling
hirseling1396271hirseling
birling104317052bir_ling
brisling112410842brisling
circling1338422circling
dirling93316072dir_ling
firstling1334422firstling
girdling1146822girdling
hassling1236802hassling
higgling14217162higgling
hilling113821772hi_lling
hirelings1365762hirelings
hiring104421602hir__ing
hirselling1444832hirselling
hissing114213142hi_ssing
histing113720372hi_sting
horsing113215582hors_ing
hurdling13288012hurdling
hurling113616412hur_ling
hurtling12318312hurtling
isling71213882_i_sling
nursling997602nursling
riesling939012riesling
thirling12248582thir_ling
thirsting1335282thirsting
tirling83315732tir_ling
warsling12198592warsling
whirling15237162whir_ling
ailing74331013ai__ling
airing74927503air__ing
airline7315033air_line
airthing12297953airthing
airting83616303air_ting
argling92812733_argling
arising83619973aris_ing
biasing103512453bias_ing
biassing11307263biassing
billing103823853bi_lling
birching16328463birching
birding114014923bir_ding
birlings11359613bir_lings
birring103713063bir_ring
birthing14338433birthing
bridling122610583bridling
brisking15329473brisking
brislings12236363brislings
bristling1246663bristling
burbling13249423burbling
burgling12239303burgling
burling104421133bur_ling
bursting1138703bursting
byrling13337373byr_ling
carling103727063car_ling
caroling113317003caroling
chilling143512183chi_lling
chirking18339383chir_king
chirming16318643chir_ming
chirping16278863chir_ping
chirring142610173chir_ring
chiseling1536403chiseling
chitling142910663chi_tling
chortling1535563chortling
crisping13319663crisping
curdling12228893curdling
curling104320183cur_ling
cursing104217033curs_ing
darkling1437483darkling
darling93418363dar_ling
dartling1039563dartling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddling12228743diddling
dieseling1146143dieseling
dimpling14199023dimpling
dindling112411163dindling
dirking133812603dir_king
dirtying1336093dirtying
discing113914593di_scing
dishing124017103di_shing
disking134615493di_sking
dissing94517683di_ssing
drilling103311983drilling
enisling949633enisling
feruling1258873feruling
fiddling14217873fiddling
filing103823763fi__ling
filling113520803fi_lling
firing104021723fir__ing
firming132811223fir_ming
firstlings1442523firstlings
fishing143913863fi_shing
fisting113818123fi_sting
fizzling20264993fizzling
frilling123011493frilling
frisking16268363frisking
furling114016563fur_ling
garbling12249453garbling
gargling11239203gargling
giggling10227043giggling
gilling93520383gi_lling
gipsying1533373gipsying
girding103611883gir_ding
girning93210693gir_ning
girthing13256083girthing
girting93113333gir_ting
gosling93312403_gosling
grilling103811533grilling
gurgling11267323gurgling
hackling183310163hackling
haggling14227273haggling
hailing113820693h_ailing
hairline1137873hair_line
hairspring1643303hairspring
hairstyling1851923hairstyling
haling104229783h__aling
handling132312713handling
hanseling1338063hanseling
harassing1346983harassing
hardline12310273hardline
haring104233003har__ing
harking154120943har_king
harming133717933har_ming
harping134118383har_ping
harrying15157643harrying
hashing145020163h_ashing
hasping134414903h_asping
hasting114725193h_asting
hauling113714433h_auling
healing113922963h_ealing
hearsing1239383hears_ing
heckling18257163heckling
heeling113618513h_eeling
heiling113616363h_eiling
heiring113312903heir__ing
heisting123411043heisting
helling114623223h_elling
heralding1435773heralding
herding122915123her_ding
herring113615883her_ring
herrying15147023herrying
hiding114319333hi__ding
hieing104216623hi__eing
highting16259723highting
hiking143617103hi__king
hilding123713533hi_lding
hilloing12158303hilloing
hilting113316893hi_lting
hinging123917123hi_nging
hinnying15124853hinnying
hinting113919223hi_nting
hipline12311423hi_pline
hipping153915103hi_pping
hircine1239143hir_cine
hirsle9159573hirsl__e
hirsled11118113hirsl_ed
hirsles101510073hirsl_es
hirudin1144753hirudin_
hirudins1244933hirudins
hissings12556753hi_ssings
hitching173310523hitching
hitting113017273hi_tting
hiving134115523hi__ving
hobbling16227583hobbling
hoising113414413hois_ing
hoisting123610903hoisting
holing104025073h__oling
hondling132210013hondling
hoppling16206763hoppling
hording123517053hor_ding
horning113015003hor_ning
hosing103421103h_os_ing
hosting114318383h_osting
houseling1337483houseling
housing113316523hous_ing
hoveling15189593hoveling
howling143413163h_owling
huddling14227293huddling
hulling113619013h_ulling
humbling16208673humbling
hurlings12388213hur_lings
hurrying15145533hurrying
hurting113914033hur_ting
hushing144514473h_ushing
husking154312053h_usking
hustling12228793hustling
idling8912883_i_dling
inkling122911303_inkling
iring66025423_ir__ing
irising83614423_irising
irking114611753_ir_king
ironing82414013_ironing
issuing836053_issuing
jiggling18226363jiggling
jingling17188573jingling
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kirning12319333kir_ning
kissing122911053ki_ssing
kitling123313573ki_tling
kittling1336063kittling
libeling1139873libeling
lisping103412753li_sping
listing84020593li_sting
lordling1077743lordling
marbling13179883marbling
marling103322763mar_ling
miauling1137343miauling
middling13249343middling
milling103223683mi_lling
mingling122010933mingling
miring93723803mir__ing
mislying1437843mi_slying
misruling1237493misruling
missing103619073mi_ssing
misting103623383mi_sting
mizzling19255443mizzling
morseling1238073morseling
nibbling13256503nibbling
nickling15278703nickling
niggling11227443niggling
nilling83619563ni_lling
nurling84215823nur_ling
nursing84012553nurs_ing
nurslings1043733nurslings
oiling74925313oi__ling
parling103823763par_ling
paroling113316213paroling
parsing103819553pars_ing
periling11316863periling
pickling17239203pickling
piddling13208953piddling
piffling1745133piffling
piling95025593pi__ling
pilling103722563pi_lling
pindling122110983pindling
pirating11314513pirating
pishing134314373pi_shing
pissing103914803pi_ssing
prilling113413413prilling
prising103321453pris_ing
prissing113011453prissing
purfling1467763purfling
purling103620293pur_ling
purpling1368543purpling
pursing103715553purs_ing
pursuing1146233pursuing
quisling18218063quisling
rassling939013rassling
riddling11249443riddling
ridgling11258203ridgling
rieslings1034493rieslings
riffling1556113riffling
rifling112815013ri_fling
riling74227973__riling
rilling84023623ri_lling
rimpling13219663rimpling
rinsing82516113rins_ing
rippling13197573rippling
rising74025883ri_s_ing
risking123914243ri_sking
rivaling1239913rivaling
ruling73219553__ruling
shieling123512403shi_eling
shilling123315383shi_lling
shingling14136973shingling
shirking163210473shir_king
shirring122910443shir_ring
shirting123213603shir_ting
shrilling13307693shrilling
sibling10814423si_bling
sickling152910333sickling
sideling101012183sideling
sidling9915423si_dling
singling101913003singling
siring75128313sir__ing
siruping1136503siruping
sizzling17225783sizzling
skirling13249063skir_ling
sling66028803___sling
spiraling1237953spiraling
swirling12249143swir_ling
thrilling13276693thrilling
tickling15309433tickling
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tinseling1036643tinseling
tippling13196703tippling
tiring74023093tir__ing
tissuing935103tissuing
titling83715793ti_tling
tousling938793tousling
trifling122411503trifling
trilling92815963trilling
tripling112712553tripling
turtling9238833turtling
tussling935823tussling
twirling12246243twir_ling
unsling8313643_unsling
versing112314193vers_ing
vialing113614163vi_aling
vialling1237223vialling
visaing11279333vi_saing
viseing11299163vi_seing
vising103915873vi_s_ing
vittling1236143vittling
warbling14198943warbling
warstling1335063warstling
whiffling2242883whiffling
whiling143511743whi__ling
whirring15286283whir_ring
whirrying1962733whirrying
whishing18287183whi_shing
whisking19286613whi_sking
whisting15329543whi_sting
whistling1644733whistling
whittling1634383whittling
widdling14228743widdling
wiggling14217293wiggling
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
winkling16298293winkling
wintling12249923wintling
wiring104521023wir__ing
wishing144114893wi_shing
wising103318223wi_s_ing
wisping133711943wi_sping
wissing113212943wi_ssing
wisting113519743wi_sting
witling113215813wi_tling
worsting1267683worsting
yirring11307763yir_ring
zizzling16233923zizzling

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623428.40617387.8
3Display Results3423420.1402442.9
 (SQL Overall)1786913428.71920494.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.