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

452 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
twirps1141501(None) 
twerps11345151twerps
twirls9478121twirls
twirp10468941twirp_
chirps135414002chirps
stirps85011822stirps
swirls94010132swirls
tarps76527112t_arps
thirds10438602thirds
thirls95012062thirls
thorps113610892thorps
thrips11299012thrips
tips66436762t_i_ps
tires55437492t_ires
tirls54519802t_irls
tiros54524892t_iros
trips74923362tri_ps
turps74918732t_urps
twerp10398412twerp_
twiers95410162twiers
twigs96911172twi_gs
twills9489792twills
twines94717272twines
twins85118982twi_ns
twirl85011942twir_l
twirly12427082twirly
twists9549752twists
twits86015792twi_ts
warps107126422_warps
wimps125213802_wimps
wires86034912_wires
wisps105214182_wisps
airns55521033_airns
airs46447423_air_s
airts55626343_airts
amirs75924923amir_s
attires72312953attires
awards107113453awards
bairns86710873bairns
birds85421333_birds
birks114920303_birks
birls74023163_birls
biros75325133_biros
birrs74917103_birrs
blimps12588153blimps
blips95615783bli_ps
burps94220173_burps
cairds96411513cairds
cairns85313303cairns
carps96932253_carps
chimps155713663chimps
chips125721253chi_ps
chirks155414843chirks
chirms135113983chirms
chiros114617773chiros
chirp124717163chirp_
chirpy16498913chirpy
chirrs114514983chirrs
chirus114615693chirus
cires74932913_cires
clips96018303cli_ps
coirs75221053coir_s
corps95927043_corps
crimps124613453crimps
crisps104411513crisps
dips75536913_di_ps
dirks105619523_dirks
dirls64720503_dirls
dirts66824463_dirts
dorps85419223_dorps
drips85417233dri_ps
dwarfs13436273dwarfs
dwines105013103dwines
emirs76116163emir_s
ewers86018823ewer_s
fairs85825443fair_s
fires85740753_fires
firms105217423_firms
firns86018543_firns
firs76637713_fir_s
flips105117743fli_ps
flirs85518933flir_s
flirts95411483flirts
gimps105915203_gimps
gips75632923_gi_ps
girds74816993_girds
girls64518393_girls
girns64516803_girns
giros65722653_giros
girts65423623_girts
gorps85316993_gorps
grips85520133gri_ps
guiros7389093guiros
hairs86225173hair_s
harps105926873_harps
heirs85618563heir_s
hips96433703_hi_ps
hires86134343_hires
imps86221123__imps
ires45639283__ires
iris45732553__iris
irks86220133__irks
iwis77117013iwi__s
keirs95313673keir_s
kips106430513_ki_ps
kirks84915263_kirks
kirns95315453_kirns
kirs85831733_kir_s
lairds74711613lairds
lairs55425873lair_s
limps95522673_limps
lips67141443_li_ps
liras56021983_liras
lisps76913913_lisps
mairs76228303mair_s
mbiras1077153mbiras
mips85534083_mi_ps
mires75640883_mires
mirks115122143_mirks
mirs66940573_mir_s
moires8915633moires
nairas6312783nairas
nairus639143nairus
nips65830923_ni_ps
noirs55615463noir_s
pairs75325833pair_s
perps95521483_perps
pimps114616983_pimps
pips85837133_pi_ps
pirns76020093_pirns
primps124711823primps
quips164713373qui_ps
quires154015743quires
quirks19419113quirks
quirts154213553quirts
rewires104717113rewires
rips66237433_ri_ps
scarps104718603scarps
scrips105316033scrips
sharps115516083sharps
ships105123773shi_ps
shires95225573shires
shirks134814123shirks
shirrs94413173shirrs
shirts94918343shirts
simps94719763_simps
sips65740103_si_ps
sires55945373_sires
sirs44338333_sir_s
sirups83710533_sirups
skimps14488043skimps
skips115616603ski_ps
skirls10449823skirls
skirrs10448193skirrs
skirts104111503skirts
slips76023723sli_ps
slurps84410003slurps
smirks124910123smirks
snips75818013sni_ps
spires84628113spires
spirts85317133spirts
stairs65416333stair_s
stirks104914243stirks
stirp76815503stirp_
stirpes95011293stirpes
stirs55921623stir_s
strips85719653stri_ps
swamps135910263swamps
swaps104819203sw_aps
swards105415133swards
swarfs125612063swarfs
swarms116112173swarms
sweeps114110513sweeps
swifts12408173swifts
swigs96213663swi_gs
swills94213363swills
swims105514143swi_ms
swings104714453swings
swinks134610653swinks
swipe105217083swi_pe
swipes114114333swipes
swirl84514143swir_l
swirly12439253swirly
swiss86712903swi_ss
swives123915183swives
swoops114910923swoops
swops105913973sw_ops
swords104510803swords
tahrs85412333tahr_s
taigas73712563taigas
tails55634193tai_ls
tains54936323tai_ns
taints64520533taints
tamps95524083t_amps
tapirs84113173tapir_s
taps66050673t__aps
tares57456563t_ares
tarns56433953t_arns
taros55640823t_aros
tarp66936413t_arp_
tarres64723043tarres
tars46763953t_ar_s
tarts57242023t_arts
tawers94118603tawer_s
tears55436463tear_s
teiids736693teiids
teinds738263teinds
temps95417133t_emps
terms75523473t_erms
terns55226873t_erns
terras63516973terras
tetras63017623tetras
tetris62816293tetris
thairms1244453thairms
tharms115712243tharms
theirs94610353their_s
theres96525473theres
therms115914873therms
thesps11448263thesps
thicks154511993thicks
thighs1346633thighs
thills95515383thills
things104914303things
thinks134613363thinks
thins85826333thi_ns
thiols95112763thiols
thir76420543thir__
thiram1139963thiram
thirams1236823thirams
third95912493thir_d
thirl85416823thir_l
thirst9312253thirst
thirsts1036243thirsts
thirty12378403thirty
this76027383thi__s
thorns95314103thorns
thorp104414263thorp_
thorpe113610093thorpe
thorpes125010353thorpes
thrip103012183thrip_
thumps13449353thumps
thurls9418713thurls
thwarts1345023thwarts
tiaras6314553tiaras
ticks115823293t_icks
tics65729633t_i_cs
tides64830153t_ides
tiers55526523t_iers
ties45248313t_i_es
tiffs114414883t_iffs
tikes95628903t_ikes
tikis95615973t_ikis
tiles55542103t_iles
tills54631713t_ills
tils45739613t_i_ls
tilts55325613t_ilts
times75630823t_imes
tines54848423t_ines
tings65329203t_ings
tins45251303t_i_ns
tints56030923t_ints
tip56551223t_i_p_
tipi69924433t_i_pi
tipis76019923t_ipis
tippy125411793t_ippy
tipsy106010503t_i_psy
tire46143353t_ir_e
tired65228903t_ired
tirl45029923t_ir_l
tiro46832363t_ir_o
tis37056643t_i__s
titis56023813t_itis
titres64718933titres
tits46145043t_i_ts
toiles63923513toiles
toils54527493toi_ls
toits55327473toi_ts
tops66248123t__ops
toras55540373t_oras
torcs75123763t_orcs
tores55352673t_ores
torics85118353torics
tories65435883tories
toros54336193t_oros
torrs53923563t_orrs
tors46157383t_or_s
torts56138123t_orts
torus54329763t_orus
tours55325893tour_s
towards1138783towards
towers94423673tower_s
towies93521193towi_es
tramps105114453tramps
traps75727483t_raps
tres46542903t__res
triacs83913223triacs
triads74513533triads
trials64319883trials
tribes85119023tribes
triceps11267343triceps
trices84826333trices
tricks125319013tricks
triens65417543triens
triers64321523triers
tries55742813tri_es
trigos74214173trigos
trigs65423063tri_gs
trikes105419493trikes
trills64319853trills
trims75021473tri_ms
trines64132563trines
triols66117803triols
trios55528093tri_os
trip66830393tri_p_
tripe75425383tri_pe
tripes85324873tripes
tripos84014923tripos
trippy13457803trippy
tromps104911703tromps
troops85712783troops
trumps104611883trumps
tsars56717113tsar_s
tsores65113663tsores
tsoris63411193tsoris
tsuris62710203tsuris
tuis44829643tui__s
tulips8137253tulips
tumps95420793t_umps
tups65628763t__ups
turds65021693t_urds
turfs84620443t_urfs
turks95320823t_urks
turns55623233t_urns
twaes86513663tw_aes
twains95811183twains
twangs10358093twangs
twas76824083tw__as
twats86616603tw_ats
tweaks1335963tweaks
tweeds10498433tweeds
tweens9489843tweens
tweets94210103tweets
twibil1133563twibil
twibils1253113twibils
twice104711123twi_ce
twier84713293twi_er
twig87615773twi__g
twiggy1432933twiggy
twilit949553twilit
twill85612723twi_ll
twin76023083twi__n
twine85822363twi_ne
twined104413123twined
twiner94012593twiner
twiners10459633twiners
twinge104210403twinge
twinges11409453twinges
twiny116012813twi_ny
twirled11385983twirled
twirler10285203twirler
twirlers11274303twirlers
twist86820983twi_st
twisty12426863twisty
twit76329063twi__t
twitch14406163twitch
twixt155512483twi_xt
twos76718023tw__os
twyers12497413twyers
tyers86220053tyer_s
typps12549303t_ypps
tyres84725233t_yres
tyros85118593t_yros
tzars144914273tzar_s
tzuris15286913tzuris
unrips8199453unrips
urps66920473__urps
usurps8105073usurps
vairs85019133vair_s
vires84529683_vires
virls85618603_virls
virus85316843_virus
wairs86424063wair_s
waps96642083_w_aps
wards97734403_wards
wares88250583_wares
warks127932403_warks
warms107726853_warms
warns87231003_warns
warp95635003_warp_
wars78659803_war_s
warts814840403_warts
wasps106714693_wasps
weeps104120563_weeps
weirds10478053weirds
weirs84316493weir_s
whaps135115163_whaps
whips134917083_whips
whirls124710533whirls
whirrs12408593whirrs
whirs115218093whir_s
whops135013933_whops
whups134210003_whups
wicks144619363_wicks
wides94832823_wides
wifes114522563_wifes
wigs84931253_wi_gs
wilds94818203_wilds
wiles85437873_wiles
wills84528963_wills
wilts85023503_wilts
wimp115521523_wimp_
wimpy155911923_wimpy
winds95425603_winds
wines85546863_wines
wings95727243_wings
winks125325433_winks
winos84625043_winos
wins75949173_wi_ns
wipe94830283_wi_pe
wipes104827083_wipes
wire75839813_wir_e
wired95327643_wired
wirer85124953_wirer
wirers94617893_wirers
wirra83210823_wirra
wiry106422833_wir_y
wis66552333_wi__s
wises85633193_wises
wisp97124073_wisp_
wispy137210973_wispy
wiss75630543_wi_ss
wists86728523_wists
wites85536963_wites
wits76044873_wi_ts
wives115328923_wives
wizes174723343_wizes
woops104917523_woops
wops96634153_w_ops
words95425073_words
works125621903_works
worms105320763_worms
worts88631183_worts
wraps105617153_wraps
wries85827743_wries
writs86624383_writs
yairds10448023yairds
yips95226703_yi_ps
yirds96612513_yirds
yirrs8469193_yirrs
ywis105313103ywi__s
zaires1539703zaires
zips155723793_zi_ps

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164525.28321335.6
3Display Results4524520.1403228.6
 (SQL Overall)1786914525.79630830.1
 
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.