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

139 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
barrack153825(None) 
arrack121110251_arrack
barracks1636881barracks
carrack1548751carrack
arracks1387732_arracks
bareback1846092bareback
barracked1844752barracked
barracker1744652barracker
barrage10710842barrage
barranca1245582barranca
barranco1244942barranco
carack142113172ca_rack
carjack2246152carjack
carracks1637712carracks
hatrack1638212hatrack
hayrack1945542hayrack
aback134816173_a_back
abreact11310823abreact
abroach1446213abroach
alack114820063_a_lack
amtrack15107393amtrack
arak86929573_a_ra_k
arrant6623253_arrant
arras55626133_arra_s
array86317143_arra_y
arrays95311683_arrays
attack12148153_attack
back125535763b___ack
backpack1945463backpack
backtrack1844243backtrack
baldrick17153623baldrick
bannock1545043bannock
barbal104016663barba_l
barbasco1443143barbasco
barbate11314543barbate
barca91319433ba_r_ca
barcas101016603barca_s
bardic11312923bardic_
baresark1443883baresark
bargain1079063bargain
baric96125693ba_ric_
bark106242153ba_r__k
barmaid1238193barmaid
barman103519703barma_n
barnacle1245943barnacle
barrable1249243barrable
barrackers1843763barrackers
barracking1944703barracking
barracoon1343303barracoon
barracuda1452353barracuda
barraged1297683barraged
barrages11711083barrages
barrancas1345093barrancas
barrancos1344193barrancos
barrater10310143barrater
barrator1048403barrator
barratry13114473barratry
barre75929543barr__e
barred95725793barr_ed
barrel84517873barr_el
barrels94514363barrels
barren85317613barr_en
barrens94414323barrens
barres84427543barr_es
barret84930483barr_et
barrets94917103barrets
barrier94017733barrier
barring104021593barring
barrio8312573barr_io
barrios9310773barrios
barroom1139373barroom
barrow114512763barr_ow
barrows123411683barrows
barware12610703barware
bawcock20144033bawcock
bedrock1645643bedrock
bipack1636523b_ipack
black134719073b__lack
bookrack1544033bookrack
brace95629273b__race
brach126123303b__rach
bract96332723b__ract
brank115222283b__rank
breach134213723b_reach
break115319403b_rea_k
brick134618153b__rick
broach133611113b_roach
brock136017073b__rock
burdock1644603burdock
buyback2045533buyback
calpack17338333calpack
caprock1736813caprock
caracks152211563ca_racks
carjacks2345573carjacks
caroach1488863caroach
carroch1437093carroch
carryback2252393carryback
carsick1536343carsick
coatrack1645843coatrack
crack134120533__crack
currach1446453currach
derrick1435803derrick
earlock1336923earlock
earmark1345653earmark
farrago1144923farrago
fatback1836923fatback
hardback2045633hardback
hardhack2143843hardhack
hardpack2043923hardpack
hardtack1843993hardtack
hatracks1737533hatracks
hayracks2045313hayracks
hayrick1944183hayrick
jarrah1636683jarra_h
jarrahs1735453jarrahs
lavrock1644223lavrock
manpack1746063manpack
maraca10314153ma_raca
marram10313883marra_m
marrams11310123marrams
marrano939423marrano
narrate7313493narrate
oarlock1336123oarlock
parral85517533parra_l
parrals94414573parrals
payback2056453payback
rack106234883___rack
ransack1346463ransack
rerack122513163_rerack
retrack131310723retrack
tamarack1644363tamarack
tarmac10310333tarmac_
tarmacs1138323tarmacs
terrace93311833terrace
track114823013__track
untrack1338703untrack
warlock1636293warlock
warrant10614243warrant
wrack145413883__wrack

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271397.55017751.9
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.76623009.4
 
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.