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

113 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
tripack156567(None) 
tripacks1664891tripacks
bipack1636522_bipack
gripsack1742582gripsack
prepack1757642prepack
repack142412162_repack
track114823012tr__ack
triac74116372tri_ac_
triacs83913222tri_acs
trick115420692tri__ck
tripart9311432tripart
airpark1344923airpark
arrack121110253ar_rack
bipacks1745043_bipacks
brick134618153bri__ck
calpack17338333calpack
crack134120533cr__ack
crick135118753cri__ck
grimace1255083grimace
gripsacks1842313gripsacks
hardpack2043923hardpack
hijack2233673_hijack
manpack1746063manpack
mudpack1843593mudpack
pack125535443___pack
prepacks1836583prepacks
prick134317503pri__ck
primacy1635603primacy
privacy1744233privacy
rack106234883_r__ack
repacks15269543_repacks
repark123511713_repark
rerack122513163_rerack
retack122612823_retack
retropack1742833retropack
rick107334653_ri__ck
skipjack2242233skipjack
strick124813203stri__ck
tack106536293t___ack
tailback1644923tailback
taipan82410663taipa_n
taipans9269553taipans
thack144915173t__hack
thick145613353thi__ck
thwack1834213t_hwack
tick106231223t_i__ck
tieback1547103tieback
tilak91011553t_ila_k
tipcat10312653t_ipcat
tomback17227743tomback
towsack1644723towsack
trace75829613tr__ace
tracks124818843tr__acks
tract75635713tr__act
traik95418203tr__aik
trank96222423tr__ank
trapan82412973trapa_n
trapans92812463trapans
traprock1643483traprock
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
triacid1038593tri_acid
triad65217723tri_a_d
triads74513533tri_ads
triage72812893tri_age
trial54926353tri_a_l
trials64319883tri_als
tribade1037293tribade
tribal8611133triba_l
tribals9610753tribals
tribrach1543733tribrach
trice75127493tri__ce
tricks125319013tri__cks
tricky154211473tri__cky
trinal6516963trina_l
trinary1039173trinary
trip66830393trip___
tripe75425383trip__e
tripes85324873trip_es
triphase1346193triphase
triplane1039113triplane
triple84215923trip_le
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
triply114211023trip_ly
tripod9399853trip_od
tripods10359053tripods
tripody13395983tripody
tripoli937133tripoli
tripos84014923trip_os
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
trippy13457803trip_py
trips74923363trip__s
triptan947543triptan
triptane1047563triptane
triptans1047363triptans
triptyca1542423triptyca
triptych1842283triptych
trisect939733trisect
troak95213573tr_oa_k
trock114817603tr__ock
tropic103014193tropic_
tropics113610653tropics
truck116115463tr__uck
umiack1435173umi_ack
unpack1457833_unpack
wrack145413883wr__ack
wrick144013393wri__ck

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 Limit1340271136.18621666.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.63826919.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.