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

189 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
jackals203689(None) 
jacals1539871jac_als
jackal1937611jackal_
jackass2034961jackass
facials123310742facials
jacal14313702jac_al_
jacales16310322jac_ales
jackdaws2542922jackdaws
jackers204214452jackers
jackets205011372jackets
jackies202912622jackies
jacks185219832jack__s
sacrals93311792sacrals
aals49941143_a__als
acetals93411353_acetals
ackees124914573_ackees
acyls104211523_ac_yls
alkali10127553_alkali
alkalis11148783_alkalis
alkyls13465723_alkyls
annals66415923_annals
appals104812943_appals
argals75517703_argals
baals76122703ba__als
babkas146010143babka_s
backers153821883backers
backhauls2044863backhauls
backlash1945923backlash
backs135729623back__s
backsaws1946803backsaws
backups1736173backups
cabals104020153ca_bals
cacaos104616183cac_aos
cacas95627983cac_a_s
cackle143416923cack_le
cackles153717203cackles
canals84421663ca_nals
cantals93919573cantals
carpals113414623carpals
casuals91410523casuals
causals91411183causals
coals76129603__coals
dachas124113253dacha_s
dackers143417043dackers
dactyls1333913dactyls
decals93717713dec_als
deckels14367363deckels
facial113615633facial_
facias113415803facia_s
fallals103310193fallals
farfals13268503farfals
faucals12326563faucals
fecials123510333fecials
fractals1346133fractals
gavials1136603gavials
gayals1039513ga_yals
hackable1937473hackable
hackees165014103hackees
hackers164619043hackers
hackies163418243hackies
hackle154916813hack_le
hackles162917063hackles
hackly18298733hack_ly
hacks144928713hack__s
hacksaws2043923hacksaws
halals95018313ha_lals
hamals114816813ha_mals
hammals14409213hammals
hartals10313023hartals
jacamars1944003jacamars
jacana1537933jac_ana
jacanas1638263jacanas
jack175224863jack___
jackaroo2143983jackaroo
jackaroos2243523jackaroos
jackasses2243713jackasses
jackdaw2442843jackdaw
jacked204817523jack_ed
jacker194417583jack_er
jacket194720673jack_et
jackfish2744123jackfish
jacking214515263jacking
jackleg2135033jackleg
jacklegs2233953jacklegs
jackpot2245013jackpot
jackpots2344003jackpots
jackroll2142743jackroll
jackrolls2252483jackrolls
jackstays2543003jackstays
jacky215412343jack__y
jacobus1843173jacobus
jagras1438463jagra_s
jaguars1535223jaguars
jails125422943ja__ils
jakes165023643ja_k_es
jalaps15299183ja_laps
japans1539823ja_pans
jarfuls1754773jarfuls
jarls126120963ja__rls
jarrahs1735453jarrahs
jauks165412463jauk__s
javas155915423ja_va_s
jawans1657843ja_wans
jaywalk2442523jaywalk
jaywalks2542143jaywalks
jingals1588063jingals
jockeys23365953jockeys
jockos19527563jock_os
jocks185118083jock__s
jouals1338923j_ouals
jumbals18106533jumbals
kakas85117343ka_ka_s
labials9299873labials
lackers134120543lackers
lackeys16458263lackeys
lacks116129203lack__s
lactams1136953lactams
lacteals1095663lacteals
locals83714503loc_als
macaws1337023mac_aws
mackle143716433mack_le
mackles154415753mackles
macks135127603mack__s
maculas113114013maculas
makars124612633ma_kars
mammals10389273mammals
manuals9311213manuals
markas124717003marka_s
miskals13369763miskals
nachas114914193nacha_s
narwals1036983narwals
nasals63312463na_sals
nickels13338653nickels
nuchals12216933nuchals
pacas96029403pac_a_s
pachas135017143pacha_s
packable1838633packable
package16128013package
packages17138733packages
packers153818893packers
packets155114773packets
packly17228333pack_ly
packs135528933pack__s
parkas125018023parka_s
parrals94414573parrals
pascals11610013pascals
paschals1566473paschals
racial83419243racial_
rackers134320453rackers
rackets134916873rackets
rackfuls1744643rackfuls
rackle123917293rack_le
racks115028853rack__s
radials83614633radials
rascals959663rascals
ratals64219583ra_tals
recoals94214623recoals
sabals84618863sa_bals
sackers133820223sackers
sackfuls1744163sackfuls
sacks114228873sack__s
sacral83414413sacral_
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
socials999633socials
tackers134319623tackers
tackets134914363tackets
tackily1637503tackily
tackle123815733tack_le
tackles133816523tackles
tacks115430133tack__s
takas95520683ta_ka_s
tamals84116623ta_mals
tankas104613763tanka_s
tarsals72512603tarsals
ticals83214713tic_als
uncials92510523uncials
vakils1337593va_kils
vandals113211663vandals
vassals1057953vassals
vocals113811583voc_als
wackes154717713wack_es
wackily1936053wackily
wackos155210993wack_os
wacks146626283wack__s
wadmals1335513wadmals
yacks144419813yack__s
zaikais2042913zaikais

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 Filter1786911340270.203880251.2
2DLD Change Limit1340271898.42315912.0
3Display Results1891890.0633000.0
 (SQL Overall)1786911898.68920565.2
 
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.