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

107 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
hijinks213200(None) 
hidings12349702hidings
hijacks2333532hijacks
jinks165019332__jinks
airings83913843airings
bikinis13346203bikinis
blinks124613573_blinks
boinks125211273_boinks
brinks124616313_brinks
chewinks20313183chewinks
chinks155817573_chinks
chitins122713793chitin_s
clinks125815063_clinks
dinks105927953__dinks
divines113514723divines
djinns1443133_djinns
djins1368453_djin_s
drinks116810713_drinks
ficins113513983ficin_s
filings115213073filings
finings114311773finings
finks125424223__finks
firings114112333firings
fixings18347443fixings
ginks104319563__ginks
haiks125120933h_ai_ks
haints94417583h_aints
hajis156716283haji__s
hanks126226863h__anks
hayings14379393hayings
hazings20378343hazings
hejiras1744233hejiras
hemins113417563hemin_s
hicks145322173h__icks
hiding114319333hidin_g
hieing104216623hiein_g
hijabs1833083hij_abs
hijack2233673hijack_
hijrahs2043443hijrahs
hijras1635773hij_ras
hiking143617103hikin_g
hildings13347503hildings
hinds96721473h__inds
hinky155618753h__inky
hinnies103615103hinnies
hins76447993h__in_s
hints87330623h__ints
hiplines13310593hiplines
hiring104421603hirin_g
hissings12556753hissings
hiving134115523hivin_g
hoicks15378283h_oicks
homines123518643homines
honks125124523h__onks
hotlinks1574193hotlinks
hunks125321453h__unks
icings9428453_icings
imines84918353_imines
inks86926503___inks
jink156227203__jink_
jinns126013843__jinns
jins115635013__jin_s
junks164815973__junks
kinins104014583kinin_s
kinks84926083__kinks
likings12539413likings
linings84313073linings
linins65922143linin_s
links96430193__links
lipins85016883lipin_s
livings11408923livings
minings103912073minings
minks115829273__minks
mirins83918903mirin_s
mujiks1964023muji_ks
oinks94819913__oinks
pilings103313613pilings
pinks115729383__pinks
pipings12338253pipings
plinks124913263_plinks
prinks124315383_prinks
reinks105012153_reinks
relinks114510223relinks
ricins83618703ricin_s
ricinus9408123ricinus
ridings93412093ridings
rinks94827103__rinks
risings83211893risings
shrinks14397913shrinks
sidings94011463sidings
sinks95529183__sinks
sizings17378013sizings
skinks94511653_skinks
slinks104315153_slinks
stinks105616833_stinks
swinks134610653_swinks
thinks134613363_thinks
tidings93810263tidings
tilings84212793tilings
timings10279303timings
unkinks10265413unkinks
unlinks11307403unlinks
uplinks13345613uplinks
vikings15386623vikings
whitings15287063whitings
winks125325433__winks
wirings113910113wirings

Search took 7 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.403443402.0
2DLD Change Limit1340271075.58024019.2
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.01329717.4
 
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.