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

166 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
imbarks1532661(None) 
embarks15337351embarks
imbark14347861imbark_
imparks15276661imparks
ambaris113112162ambaris
barks115735812__barks
debarks14388492debarks
embanks15295702embanks
embark14458522embark_
embars103812882embar_s
imbalms1334552imbalms
imbarked17254062imbarked
impark14287072impark_
imparts11298532imparts
marks115933482_m_arks
mimbars1397382mimbar_s
airparks1443913airparks
ambages1269623ambages
ambari103012173ambar_i
ambaries123312383ambaries
ambary134010543ambar_y
ambers104519583amber_s
arks85936873___arks
backs135729623__backs
balks114926293__balks
banks115527903__banks
barbs95928193__barbs
bards87139643__bards
bares75457133__bares
barfs104826003__barfs
bark106242153__bark_
barky145721613__barky
barms96128473__barms
barns76335143__barns
bars66564093__bar_s
basks115621763__basks
berks115423123__berks
birks114920303__birks
bombards1536493bombards
borks115727703__borks
carks115534213__carks
charks155219703_charks
darks106727873__darks
debark134210943debark_
debars94218043debar_s
demarks14339233demarks
diebacks1745963diebacks
disbars10310323disbar_s
disembarks1953123disembarks
embalms1335333embalms
embank14346553embank_
embar94011603embar__
embargo1243033embargo
embarked17205223embarked
embays131408333emba_ys
embers104116183ember_s
embosks1594463embosks
finbacks1965363finbacks
finmarks17154473finmarks
gimbals12257823gimba_ls
harks126333433__harks
images91411463im_ages
imagos9117553im_agos
imams91511113im_a_ms
imaret81121233im_aret
imarets9138643im_arets
imaums10106303im_aums
imbalm1246323imba_lm
imbarking1843613imbarking
imbeds11456743imb_eds
imbibes1334693imbibes
imblazes2144723imblazes
imbrue1035153imb_rue
imbrues1135503imbrues
imbues1037983imb_ues
immures1136713immures
impacts13266503impacts
impairs1135823impairs
impalas11236953impalas
impales113311763impales
imparked17264863imparked
impart102715143impar_t
impawns1433323impawns
impearls1253883impearls
imports11309623imports
inarms8410093i_narms
inboards1145843inboards
infares10313023infares
innards837153innards
invars9310003invar_s
inwards1138343inwards
irks86220133i___rks
ironbarks1542703ironbarks
isbas71010403isba__s
isobares1046513isobares
isobars936593isobar_s
izars145112933i_zar_s
izzards16143963izzards
kabars124513953kabar_s
kbars114612603_kbar_s
kebars124112493kebar_s
larks95227813__larks
limbas105313203limba__s
limbecks1843353limbecks
limbers113614743limber_s
lumbars11289763lumbar_s
maars74621633_maar_s
macks135127603_m_acks
maras75443303_m_aras
marcs95726623_m_arcs
mares76457633_m_ares
mark105138063_m_ark_
marka114620803_m_arka
markas124717013_m_arkas
marls75535163_m_arls
mars66261873_m_ar_s
marts77442233_m_arts
masks115320533_m_asks
mbiras1077153_mbiras
merks114722403_m_erks
mimbar1297493mimbar__
mirks115122143_m_irks
mismarks1645893mismarks
murks114821733_m_urks
narks96026033__narks
ninebarks1543683ninebarks
ombers104214403omber_s
ombres103911143omb_res
outbarks1437833outbarks
parks116134463__parks
quarks193810913_quarks
rebars84019833rebar_s
reembarks1743493reembarks
remarks13329983remarks
reparks13249513reparks
ringbarks1643483ringbarks
sambars115113843sambar_s
sarks96632463__sarks
sharks135019723_sharks
simars84916933sim_ar_s
smacks144112323sm_acks
smarms105712533sm_arms
smarts86218003sm_arts
smears84714433smear_s
smerks12449713sm_erks
smirks124910123sm_irks
snarks104815733_snarks
sparks124616363_sparks
squarks20417183squarks
tabards10310383tabards
tambaks15218153tamba_ks
tanbarks1445563tanbarks
tiebacks1646333tiebacks
timbales12227843timbales
timbals11239533timba_ls
timbers113111853timber_s
timbres11249353timb_res
titlarks1243693titlarks
tombacks18216463tombacks
tombaks15246863tomba_ks
umbers104215213umber_s
umbras1038643umb_ras
umiacks1534013umiacks
umiaks1244953umia_ks
unbars82113033unbar_s
warks127932403__warks

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.406440125.6
2DLD Change Limit1340271665.92022639.7
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.38927968.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.