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 “swirl” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
swirl8451414(None) 
aswirl935091aswirl
skirl96012911skirl
swill83417371swill
swirls94010131swirls
swirly12439251swirly
twirl85011941twirl
awhirl1264672awhirl
birl65830472_birl
dirl57430022_dirl
girl56226552_girl
sail45447162sai_l
shiel811023772shiel
shill85325332shill
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shorl84720252shorl
sial45938832s_ial
sill45545152s_ill
sir35746672s_ir_
sire46150412s_ire
sirs44338332s_irs
skill94316722skill
skirls10449822skirls
skirr94810542skirr
skirt95624662skirt
smirk116612752smirk
snarl54921082snarl
soil46138832soi_l
spiel74623912spiel
spill74821162spill
spiral83715342spiral
spire75828692spire
spirt75032952spirt
spiry105017352spiry
still54922082still
stir45723252stir_
stirk95717412stirk
stirp76815502stirp
stirs55921622stirs
swail86217162swail
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swell84815982swell
swift116818052swift
swig85818022swi_g
swigs96213662swigs
swills94213362swills
swim96221402swi_m
swims105514142swims
swine85625302swine
swing96124842swing
swink125116352swink
swipe105217082swipe
swiple11379232swiple
swirled11308222swirled
swish115114822swish
swiss86712902swiss
swith115917402swith
swive115316192swive
swivel12369322swivel
sword95214122sword
swore84920822swore
sworn86115312sworn
thirl85416822thirl
tirl45029922_tirl
twill85612722twill
twirls9478122twirls
twirly12427082twirly
twirp10468942twirp
virl76224472_virl
whirl114913822whirl
will75737512_will
wire75839812_wire
wiry106422832_wiry

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800801.56334421.0
3Display Results80800.0302666.7
 (SQL Overall)178691801.90693751.8
 
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.