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

108 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
vortical134886(None) 
cortical12412201cortical
vertical13410431vertical
erotical101911982erotical
fornical1347792fornical
optical1149862_optical
poetical12311532poetical
vatical1239982v_atical
verticals1457232verticals
verticil1366912verticil
viatical1347062viatical
vortically1849172vortically
vortices1369122vortices
acritical1348123acritical
aortal65217513aort__al
aortic8316613aortic__
biotical1248863biotical
cervical1546853cervical
comical13312223co_mical
conical11316203co_nical
cordial10312933cordi_al
corrival1346143corrival
cortically17411803cortically
corticate13410763corticate
cortices12615003cortices
cortina91915963cortina_
cortinas102212423cortinas
cortisol1045403cortisol
cosmical1448013cosmical
cotidal1038453co_tidal
critical12310263critical
domical1239373do_mical
erotica92811513erotica_
erratical1146903erratical
farcical1546953farcical
forbidal1444823forbidal
formica1436443formica_
formicas1545993formicas
georgical1344023georgical
gestical1138983gestical
gnostical1246193gnostical
haptical1547343haptical
hectical1547933hectical
heretical1448633heretical
heroical13410013heroical
iatrical1049273iatrical
ironical1049963ironical
logical1038513lo_gical
lorica8310443lor_ica_
loricae938253lor_icae
lyrical1236493lyr_ical
martial92415413marti_al
metical11315363_metical
metrical12311583metrical
morainal1047193morainal
mortal84616853mort__al
mortice11711493mortic_e
morticed1377163morticed
mortices12711553mortices
mortician1346993mortician
mystical1546933mystical
nautical1057703nautical
nodical1049863no_dical
nontidal948663nontidal
optimal1145783_optimal
orbital936923_orbital
ordinal838633_ordinal
orphical1546723_orphical
partial92616263parti_al
piratical1348653piratical
political1349713political
pollical1247953pollical
portal84218463port__al
portico11310143portic_o
porticos1238373porticos
pyritical1646983pyritical
rustical1048393rustical
septical1259363septical
statical1039423statical
surgical1146253surgical
tactical1248843tactical
tertial7313853terti_al
thetical1349123thetical
tical76021493___tical
topical1139953to_pical
toroidal966383toroidal
tortilla845893tortilla
toxical1637643to_xical
tropical1248733tropical
turrical1046203turrical
venatical1446793venatical
veridical1545983veridical
vertically18410913vertically
vertices13612273vertices
verticils1446183verticils
vesical12159813v_esical
viatica1245863viatica_
viaticals1444073viaticals
virginal1244573virginal
virtual1045913virt_ual
vocal104715643vo___cal
vomica1336383vo_mica_
vomicae1445303vo_micae
vorticella1552443vorticella
vorticism1646383vorticism
vorticist1448153vorticist
vorticity1746143vorticity
vorticose1444193vorticose

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 Filter1786911461620.216827273.1
2DLD Change Limit1461621087.67319048.9
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.93522519.3
 
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.