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

173 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
aswirl93509(None) 
swirl84514141_swirl
aspire8612122aspire
astir55517092astir_
aswarm11107912aswarm
awhirl1264672awhirl
skirl96012912_skirl
swill83417372_swill
swirls94010132_swirls
swirly12439252_swirly
twirl85011942_twirl
aboil72217543aboi_l
abseil837183absei_l
achiral12109183achiral
admiral1046363admiral
admire949933admire
aecial84817313aecial
aerial64625713aerial
affirm1435523affirm
afire86215913a_fire
ail37171043a__i_l
air38058393a__ir_
airn46433833a__irn
airs46447423a__irs
airt45757783a__irt
airy75734153a__iry
amir65129753a_mir_
amirs75924923a_mirs
anil46437433a_ni_l
answer936893answer_
answers1037043answers
anvil82712603anvi_l
argil65116883argi_l
ariel55228973a_riel
aril45843023a_ri_l
asci66519143asci__
asdic83814093asdi_c
asdics9439863asdics
ashier94714833ashier
ashing107824093ashing
ashore9414613ashore
aside65122083as_ide
asker96418783asker_
askers105915403askers
asking116017233asking
asocial998653asocial
asper75520433asper_
aspers86220313aspers
aspic95114733aspi_c
aspics104211563aspics
aspired1068173aspired
aspirer967903aspirer
aspires9612043aspires
aspirin937823aspirin
aspis74618143aspi_s
aspish114810333aspish
assail6610153assail
assert64922583assert
assign736783assign
assist6314603assist
assize1538633assize
assoil688543assoil
assort64916383assort
assure6610773assure
aster55434893aster_
astern64815813astern
asters65631603asters
astral66919283astral
aswoon947013aswoon
atrial65418943atrial
attire62412383attire
audial7312993audial
avail8313883avai_l
award97118043a_ward
aware86420023a_ware
awful1178143a_wful
awing96827323a_wing
awl67635303a_w__l
awol75620673a_w_ol
awry107619683a_w_ry
axial124515193a_xial
axil116424453a_xi_l
basil75122273bas_i_l
batgirl1043393batgirl
birl65830473__birl
busgirl1044143busgirl
cowgirl1353273cowgirl
dirl57430023__dirl
espial839543espial
fascial1258303fascial
girl56226553__girl
haywire1644743haywire
nasial6413283nas_ial
pastil85018323pasti_l
rewire95421413rewire
sabir75917003sabir_
sabirs85414633sabirs
sail45447163_sai_l
samiel8313333samiel
satire63218003satire
sawbill1255293sawbill
sawer85026213sawer_
sawers94620163sawers
sawing104323813sawing
sawmill1244073sawmill
shiel811023773_shiel
shill85325333_shill
shire84727133_shire
shirk124817843_shirk
shirr84716923_shirr
shirt84533903_shirt
shorl84720253_shorl
sial45938833_s_ial
sill45545153_s_ill
sir35746673_s_ir_
sire46150413_s_ire
sirs44338333_s_irs
skill94316723_skill
skirls10449823_skirls
skirr94810543_skirr
skirt95624663_skirt
smirk116612753_smirk
snarl54921083_snarl
soil46138833_soi_l
spiel74623913_spiel
spill74821163_spill
spiral83715343_spiral
spire75828693_spire
spirt75032953_spirt
spiry105017353_spiry
still54922083_still
stir45723253_stir_
stirk95717413_stirk
stirp76815503_stirp
stirs55921623_stirs
swail86217163_swail
sward94221463_sward
sware85828213_sware
swarf115324653_swarf
swarm106218843_swarm
swart86234643_swart
swell84815983_swell
swift116818053_swift
swig85818023_swi_g
swigs96213663_swigs
swills94213363_swills
swim96221403_swi_m
swims105514143_swims
swine85625303_swine
swing96124843_swing
swink125116353_swink
swipe105217083_swipe
swiple11379233_swiple
swirled11308223_swirled
swish115114823_swish
swiss86712903_swiss
swith115917403_swith
swive115316193_swive
swivel12369323_swivel
sword95214123_sword
swore84920823_swore
sworn86115313_sworn
thirl85416823_thirl
tirl45029923__tirl
twill85612723_twill
twirls9478123_twirls
twirly12427083_twirly
twirp10468943_twirp
virl76224473__virl
whirl114913823_whirl
will75737513__will
wire75839813__wire
wiry106422833__wiry

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 Limit1127161735.22021593.1
3Display Results1731730.0463760.9
 (SQL Overall)1786911735.63931688.4
 
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.