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 “blini” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
blini7551927(None) 
blin67228171blin_
blind86319321blind
blinis85313681blinis
blink115720141blink
ablins8316192ablins
acini75718982acini
alibi7514222alibi
aline57243152aline
baling94829692baling
bani65334952b_ani
being84920502being
benni74715362benni
bidi78226562b_idi
bikini12418912bikini
bin56658632b_in_
bind76234502b_ind
bindi85617012b_indi
bine66650852b_ine
binit76431582b_init
bins66548242b_ins
bint67355032b_int
blain75421792blain_
blains84516372blains
bland85320452bland
blank115418552blank
blend85317452blend
blent76230952blent
blimp115612942blimp
blimy125212822blimy
blinds95111612blinds
blinks124613572blinks
blintz1788842blintz
blip88322772bli_p
blips95615782blips
bliss75616912bliss
blite76225352blite
blitz165318132blitz
blond85618372blond
bluing94914482bluing
blunt75525022blunt
boing84725552boing
boink115516332boink
brin67038192brin_
brine75132272brine
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
byline11311642byline
cline76428532cline
cling86424672cling
clinic104312792clinic
clink115320042clink
elint55436472elint
fling97023512fling
flint87333502flint
glint66830182glint
lin37967372_lin_
line46965572_line
ling57447962_ling
linin58025522_linin
link86943442_link
linn46034592_linn
lino46343372_lino
lins47059052_lins
lint416266232_lint
liny78141322_liny
liri45128252_liri
mini65634542_mini
plink115219122plink
sling66028802sling
slink95422912slink

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800731.87628678.0
3Display Results73730.0135615.4
 (SQL Overall)178691731.98290156.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.