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

114 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
hijack223367(None) 
hijacks2333531hijacks
bipack1636522bipack
hack135134542h__ack
hick135530302hi__ck
highjack2852572highjack
hijab1736802hija_b
hijabs1833082hijabs
hijacked2542372hijacked
hijacker2442462hijacker
jack175224862__jack
aback134816173_aback
alack114820063_alack
arrack121110253arrack
attack12148153attack
back125535763__back
biface1358103biface
bipacks1745043bipacks
black134719073_black
carack142113173carack
carjack2246153carjack
chick165419133chi__ck
clack134720173_clack
crack134120533_crack
dick116432383di__ck
didact10711203didact
dieback1646913dieback
finback1865823finback
flack144519413_flack
hacek145411843h__acek
hacks144928713h__acks
haik115526983h__aik
hank115134143h__ank
hark115237393h__ark
hatrack1638213hatrack
hawk145521153h__awk
hayrack1945543hayrack
heck135826493h__eck
hibachi1744203hibachi
hic86540563hi__c_
hicks145322173hi__cks
highjacks2952693highjacks
hijackers2542323hijackers
hijacking2642763hijacking
hijinks2132003hijinks
hijra1535643hij_ra
hijrah1934283hijrah
hijrahs2043443hijrahs
hijras1635773hijras
hila76228353hila__
hilar85418143hila_r
hillock1646693hillock
hitch134515473hi_tch
hock136031303h__ock
hogback1945453hogback
hoick145210683h_oick
hopsack1845273hopsack
huck135927633h__uck
ick97329323_i__ck
jacks185219833__jacks
jacky215412343__jacky
jauk155816093__jauk
jock176522643__jock
kick96026063ki__ck
knack104311043_knack
kyack13468263_kyack
lack105837683__lack
lick106935073li__ck
lilac7311073lilac_
lilacs837483lilacs
linac7315413linac_
linacs8310813linacs
mack125733653__mack
mick126333433mi__ck
misact10316683misact
nick106627603ni__ck
pack125535443__pack
pick125933813pi__ck
piracy1339473piracy
plack135017843_plack
quack203812503_quack
rack106234883__rack
repack142412163repack
rerack122513163rerack
retack122612823retack
rick107334653ri__ck
sack105337313__sack
shack145321753_shack
sick106435573si__ck
skipjack2242233skipjack
skyjack2242763skyjack
slack115021763_slack
smack134615453_smack
snack114718063_snack
stack114421693_stack
tack106536293__tack
thack144915173_thack
thick145613353thi__ck
thwack1834213thwack
tick106231223ti__ck
tieback1547103tieback
tilak91011553tila_k
track114823013_track
tripack1565673tripack
umiack1435173umiack
unpack1457833unpack
untack1239763untack
vivace1436553vivace
wack135330913__wack
whack174813023_whack
whitrack2043533whitrack
wick135726303wi__ck
wrack145413883_wrack
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.376475242.0
2DLD Change Limit1127161144.92322895.8
3Display Results1141140.0303800.0
 (SQL Overall)1786911145.32933531.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.