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

249 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
troika103549(None) 
troikas1135031troikas
traik95418202traik_
traiks104013712traiks
trike95320162tr_ike
troak95213572troak_
troaks104410602troaks
trock114817602trock_
trocks123614632trocks
trois57226092troi_s
troke94821052tro_ke
trona54118952tro_na
aria46245423ar_i_a
arnica8310443arnica
aroid65428343aroi_d
aroids75118223aroids
aroint6328153aroint
aroma71220143aro_ma
arriba867683arriba
atria56022343atr_i_a
brock136017073brock_
brocks145214153brocks
broil74918223broi_l
broils84114173broils
broke116019783bro_ke
brook114717763brook_
brooks125813883brooks
coria75828323cori_a
croak115216633croak_
croaks125812983croaks
croaky15528483croaky
crock135921993crock_
crocks145118423crocks
crojik1934113crojik_
crojiks2033173crojiks
crook115217573crook_
crooks124914413crooks
droid74218543droi_d
droids84712583droids
droit65127123droi_t
droits74314313droits
drosky14486163drosky
drouk1039433drouk_
drouks1137123drouks
erica7316543er_ica
erotica92811513erotica
frock145314653frock_
frocks154111213frocks
groin65521083groi_n
groins73917203groins
grok95819683gro_k_
groks105716123gro_ks
haika125313793_haika
hooka125513903_hooka
iroko939663iro_ko
krona93611793kro_na
lorica8310443lorica
moira71012023_moira
noria55722183nori_a
oka76926803__o_ka
oroide7311703oroide
pika106322953__pika
polka11310413_polka
prima95019343pr_ima
proa66229963pro__a
protea82214763protea
quokka1841893quokka
raia46638383_rai_a
raita54623073_raita
ria36745503_r_i_a
rioja1236303_rioja
rock105735183_rock_
rocks114626413_rocks
rocky144513853_rocky
roil46235293_roi_l
roils54826793_roils
roily86121113_roily
rook85532033_rook_
rooks95325043_rooks
rooky126117623_rooky
rota45834343_ro_ta
sika86021323__sika
stria55723213str_i_a
strike105619733str_ike
strobila1044933strobila
stroke105116173stro_ke
stroma84313073stro_ma
strook10410303strook_
tafia84215493tafi_a
taiga64115663t_aiga
taka87623593t__aka
talooka1143493talooka
taluka10426773taluka
tanka93817483t_anka
tarok97921073taro_k_
taroks106115283taro_ks
tarsia65514273tarsi_a
telia55821143teli_a
tenia55324483teni_a
terbia8311153terbi_a
thoria93012893thoria
tibia7312403tibi_a
tike85534483t__ike
tiki87620843t__iki
tikka835573t_ikka
toea46732333t_o_ea
toga57027413t_o_ga
toil46536283t_oi_l
toile54626493t_oile
toils54527493t_oils
toit46353063t_oi_t
toits55327473t_oits
tokay125513053t_o_kay
toke86738493t_o_ke
tola45236333t_o_la
tonga65619693t_onga
took86531073t_ook_
tora47545993t_o_ra
tori47542153tori__
toric76529313tori_c
torics85118353torics
tories65435883tories
torii55521593tori_i
toroid7416013toroi_d
toroidal966393toroidal
toroids8310643toroids
torsk94915773torsk_
torsks10549123torsks
torta55925353t_orta
torula6610393torula
track114823013track_
tracks124818843tracks
traiked123310453traiked
trail55126773trai_l
trails64622513trails
train56529113trai_n
trains64725343trains
trait56940843trai_t
traits65121983traits
trank96222423trank_
tranks104017763tranks
trauma838803trauma
trek86222313tr_ek_
treks96016853tr_eks
triac74116373tr_iac
triad65217723tr_iad
trial54926353tr_ial
tribal8611133tr_ibal
tribe74420273tr_ibe
trice75127493tr_ice
trick115420693tr_ick
tricks125319013tricks
tricky154211473tricky
tried65026913tr_ied
trier54328533tr_ier
tries55742813tr_ies
trig55528163tr_i_g
trigo65716053tr_igo
trigs65423063tr_igs
trikes105419493tr_ikes
trill55122933tr_ill
trim65329523tr_i_m
trims75021473tr_ims
trinal6516963tr_inal
trine54734603tr_ine
trio45233343tr_i_o
triode75311893triode
triol55521363tr_iol
triols66117803triols
trios55528093tr_ios
triose64715383triose
trip66830393tr_i_p
tripe75425383tr_ipe
trips74923363tr_ips
trite54730033tr_ite
trivia938503trivia
troaked12438253troaked
trocar848773trocar
trochal1288243trochal
trochar1257073trochar
troche113112513troche
trocked144312243trocked
trod57627953tro__d
trode65322853tro_de
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troilus736413troilus
troked114114583troked
trokes104019263trokes
troking123514103troking
troll54416533tro_ll
trolls64613943trolls
trolly94012363trolly
tromp95815803tro_mp
trompe105611263trompe
tromps104911703tromps
tronas63816903tronas
trone55131863tro_ne
trones65629283trones
troop76417533tro_op
troops85712783troops
trooz145016153tro_oz
trop66833303tro__p
trope75725803tro_pe
tropes84824353tropes
trophy1438283trophy
tropic103014193tropic
tropical1248733tropical
tropics113610653tropics
tropin83316753tropin
tropine93116653tropine
tropins93116313tropins
tropism1139293tropism
trot46351313tro__t
troth85622203tro_th
troths95414153troths
trots56629943tro_ts
trotyl9236673trotyl
trough108512023trough
troupe84812433troupe
trout57332573tro_ut
trouts66116633trouts
trouty95211793trouty
trove85221923tro_ve
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trowing113413703trowing
trows88826183tro_ws
trowth1277883trowth
troy77429683tro__y
troys86418613tro_ys
truck116115463truck_
trucks124711973trucks
truing73913933truing
truism8118623truism
trunk94713043trunk_
trunks10429753trunks
trying104214073trying
tryma1037223tr_yma
tunica8379813tunica
tupik1149003tupik_
tupiks1235493tupiks
urbia7311143urbi_a
vodka1354343_vodka
voila84813943_voila

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162495.89019136.8
3Display Results2492490.0763276.3
 (SQL Overall)1786912496.35928100.5
 
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.