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

168 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
bikinis1334620(None) 
bikini12418911bikini_
bakings144312022bakings
bikies124515162biki_es
biking135018172bikin_g
bikinied1543512bikinied
birianis1056352birianis
blinis85313682b_linis
likings12539412likings
vikings15386622vikings
aikidos1253883aikidos
airings83913843airings
alkines114415733alkines
askings12519173askings
backings174012213backings
baking135626623bakin_g
bankings15489403bankings
basins85722763basin_s
begins94415303begin_s
behinds1335283behinds
beings94613033b_eings
bekiss1236373beki_ss
bennis84314803b_ennis
bialis83617163bi_alis
biddings13397563biddings
biding104720793bidin_g
bidis86721153b__idis
biennia994933biennia
biffins15358533biffin_s
biggings13327473biggings
biggins113410693biggin_s
bikers124517553bik_ers
bikes117529473bik__es
bikie113915883bik__ie
bilious9310933bilious
bilking144413553bilkin_g
billings113412633billings
bindings123810473bindings
bindis94614583bi_ndis
binds86627483b__inds
bines76946793b__ines
binit76431583b__init
binits85716673bini_ts
bins66548263b__in_s
bints76130183b__ints
bionic103614573bi_onic
bionics114310873bionics
bionts8612393bi_onts
biotins93114453biotin_s
birdings12378823birdings
biriani945643biriani_
birkies133712433birki_es
birlings11359613birlings
biryanis1344043biryanis
bisons83914373bison_s
biting95321823bitin_g
bittings11339293bittings
bivinyl1542733bivinyl
bivinyls1641873bivinyls
bizones1837823bizones
blains84516373blain_s
blinds95111613b_linds
blini75519273b_lini_
blinks124613573b_links
bluings10327963bluings
bodings113711653bodings
bodkins1438313bodkin_s
boings96416873b_oings
boinks125211273b_oinks
bookings15358733bookings
borings103614243borings
bovines12412663bovines
bowings133612003bowings
boxings17429163boxings
brainish1338813brainish
brains85125473brain_s
brines85028853b_rines
brings94618433b_rings
brinies93317923b_rinies
brinish1239963b_rinish
brinks124616313b_rinks
brins75533973b_rin_s
brokings15317713brokings
bruins86014953bruin_s
bumkins15318013bumkin_s
burins84221893burin_s
busings103711223busings
buskins133310943buskin_s
bylines1239243bylines
criminis12257303criminis
diking124320243dikin_g
diminish14127523diminish
divines113514723divines
divinise1267143divinise
eikones1137853eikones
eikons1038503eikon_s
ficins113513983ficin_s
filings115213073filings
finings114311773finings
finis86824263__finis
firings114112333firings
firkins1437663firkin_s
fixings18347443fixings
hidings12349703hidings
hijinks2132003hijinks
hiking143617103hikin_g
icings9428453_icings
ikons96311013_ikon_s
imines84918353_imines
iritis63113733_iritis
jinnis13489053ji_nnis
kinas95626923__kinas
kinds106221833__kinds
kines95039143__kines
kings105825573__kings
kinin94917333__kinin
kinins104014583__kinins
kinks84926093__kinks
kinos96626153__kinos
kins85747923__kin_s
kiwis12328593__kiwis
lakings124713513lakings
lickings15298143lickings
likens105613703liken_s
liking114319583likin_g
linings84313073linings
linins65922143linin_s
lipins85016883lipin_s
livings11408923livings
makings145413163makings
miking134218463mikin_g
minings103912073minings
minis75432993__minis
mirins83918903mirin_s
pekins121812233pekin_s
pickings17359383pickings
piking133719643pikin_g
pikis115116393pik__is
pilings103313613pilings
pinkings15338143pinkings
pipings12338253pipings
pipkins15328183pipkin_s
ricins83618703ricin_s
ricinus9408123ricinus
ridings93412093ridings
risings83211893risings
sidings94011463sidings
siskins1159583siskin_s
sizings17378013sizings
skiings12295733skiings
skinks94511653_skinks
skins94723473_skin_s
tahinis1048013tahinis
takings124512573takings
takins105117403takin_s
tankinis12245913tankinis
tickings15368583tickings
tidings93810263tidings
tikis95615973tik__is
tilings84212793tilings
timings10279303timings
unkinks10265413unkinks
viking143414613vikin_g
wakikis1342623wakikis
wickings18357183wickings
wikiups16132083wikiups
wirings113910113wirings
yoginis11457683yoginis

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.390458182.1
2DLD Change Limit1340271686.19021652.2
3Display Results1681680.0463652.2
 (SQL Overall)1786911686.62626968.2
 
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.