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

262 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
arrack12111025(None) 
arracks1387731arracks
barrack1538251barrack
carrack1548751carrack
aback134816172a_back
alack114820062a_lack
amtrack15107392amtrack
arak86929572a_ra_k
arrant6623252arrant
arras55626132arra_s
array86317142arra_y
arrays95311682arrays
attack12148152attack
barracks1636882barracks
carack142113172carack
carjack2246152carjack
carracks1637712carracks
crack134120532_crack
hatrack1638212hatrack
hayrack1945542hayrack
rack106234882__rack
rerack122513162rerack
track114823012_track
wrack145413882_wrack
abaca95118043a_baca
abaci94718843a_baci
abbacy1536623abbacy
abrade9313053abrade
abreact11310823abreact
abroach1446213abroach
acock132110213a_cock
aerate64830553aerate
afraid1049713afraid
agrafe1038093agrafe
airpark1344923airpark
airsick1395333airsick
alpaca1047383alpaca
amtrac10109123amtrac_
amtracks1696633amtracks
amtracs1198883amtracs
amuck1389563a_muck
anarch11310393anarch
anlace82513923anlace
anorak1038923anora_k
antick124814583antick
apace94718383a_pace
apeak115513453apea_k
araks94820883a_raks
arame75026623a_rame
arc510250903a_r_c_
arcade91013643arcade
arcana8912583arcana
arcane81216743arcane
arch98628443a_r_ch
arco68331543a_r_co
arcs67834783a_r_cs
area45843393area__
areae55229743area_e
areal55928733area_l
areas55935773area_s
areca75618633a_reca
arecas84817443arecas
areic73219393areic_
argal65023383arga_l
argala74712663argala
argali75013743argali
argals75517703argals
arhat8327093arha_t
arhats9312973arhats
aria46245423aria__
ariary94114203ariary
arias55438023aria_s
ark77044963a_r__k
armada938783armada
armlock1544313armlock
arnica8310443arnica
arraign845063arraign
arrange838683arrange
arrased8149863arrased
arrases71214543arrases
arrayal1055843arrayal
arrayed11117153arrayed
arrayer10136703arrayer
arrear6310253arrear
arrears738843arrears
arrest63722633arrest
arriba867683arriba
arris56824683arr_is
arrive91311793arrive
arroba898663arroba
arrow83414883arr_ow
arrows92813483arrows
arrowy12288273arrowy
arroyo936963arroyo
artal55525473arta_l
arval86017013arva_l
asrama839193asrama
attach11118393attach
attacks13126943attacks
attract9511833attract
aura45836253aura__
aurae54128113aura_e
aural54428963aura_l
aurar54420253aura_r
auras55932553aura_s
aurate64426473aurate
auric74521723auric_
back125535763__back
bareback1846093bareback
barracked1844753barracked
barracker1744653barracker
barrage10710843barrage
barranca1245583barranca
barranco1244943barranco
bipack1636523bipack
black134719073_black
brace95629273_brace
brach126123303_brach
bract96332723_bract
brank115222283_brank
breach134213723breach
break115319403brea_k
brick134618153_brick
broach133611113broach
brock136017073_brock
calpack17338333calpack
caprock1736813caprock
caracks152211563caracks
carjacks2345573carjacks
caroach1488863caroach
carroch1437093carroch
carryback2252393carryback
carsick1536343carsick
clack134720173_clack
coatrack1645843coatrack
cracks144817003_cracks
cracky175010223_cracky
crank114819613_crank
creak115418433crea_k
crick135118753_crick
croak115216633croa_k
crock135921993_crock
cruck135615323_cruck
curacy1339593curacy
currach1446453currach
derrick1435803derrick
drank104816203_drank
dreck124812803_dreck
earlock1336923earlock
earmark1345653earmark
errancy1256363errancy
errand758793errand
errant6618733errant
errata639013errata
farrago1144923farrago
fatback1836923fatback
flack144519413_flack
frank124417513_frank
freak125115243frea_k
frock145314653_frock
grace85124543_grace
hack135134543__hack
hardback2045633hardback
hardhack2143843hardhack
hardpack2043923hardpack
hardtack1843993hardtack
hatracks1737533hatracks
hayracks2045313hayracks
hayrick1944183hayrick
hijack2233673hijack
jack175224863__jack
jarrah1636683jarra_h
jarrahs1735453jarrahs
knack104311043_knack
kyack13468263_kyack
lack105837683__lack
lavrock1644223lavrock
mack125733643__mack
manpack1746063manpack
maraca10314153maraca
marram10313883marra_m
marrams11310123marrams
marrano939423marrano
narrate7313493narrate
oarlock1336123oarlock
orach105219233_orach
orra46120723orra__
orrice81410163orrice
pack125535443__pack
parral85517533parra_l
parrals94414573parrals
payback2056453payback
piracy1339473piracy
plack135017843_plack
prank115019453_prank
preach133613923preach
preact103220393preact
prepack1757643prepack
prerace11414123prerace
prerock1536723prerock
prick134317503_prick
quack203812503_quack
race66746263__race
racks115028853__racks
racy95825683__racy
rank85135523__rank
ransack1346463ransack
reach105123883_reach
react74634333_react
reck106130563__reck
repack142412163repack
reracks132310533reracks
retack122612823retack
retrack131310723retrack
rick107334653__rick
roach105717003_roach
rock105735183__rock
ruck104728333__ruck
sack105337313__sack
serac75925203serac_
seracs84418573seracs
shack145321753_shack
shrank13359123shrank
slack115021763_slack
smack134615453_smack
snack114718063_snack
stack114421693_stack
strick124813203strick
struck12489263struck
tack106536293__tack
tamarack1644363tamarack
tarmac10310333tarmac_
tarmacs1138323tarmacs
terrace93311833terrace
thack144915173_thack
thwack1834213thwack
trace75829613_trace
tracks124818843_tracks
tract75635713_tract
traik95418203_traik
trank96222423_trank
triac74116373triac_
triacs83913223triacs
trick115420693_trick
tripack1565673tripack
troak95213573troa_k
trock114817603_trock
truck116115463_truck
turaco839453turaco
umiack1435173umiack
unpack1457833unpack
untack1239763untack
untrack1338703untrack
wack135330913__wack
warlock1636293warlock
warrant10614243warrant
whack174813023_whack
wracks154711113_wracks
wreak125513273wrea_k
wreck144611043_wreck
wrick144013393_wrick
yack135425973__yack

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.1261418182.5
2DLD Change Limit1127162625.67019879.4
3Display Results2622620.0803275.0
 (SQL Overall)1786912625.87630410.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.